B
Bonsai Bill
I have a named sheet (Raw Data) where user pastes in data from another
program. Data are copied to a hidden sheet where data are cleaned up for use
by macros. Whenever user changes Raw Data sheet the program offers user
option of updating the hidden sheet. Sometimes updates are just changing a
few cells but often the complete sheet is pasted in.
I need to prevent user from inadvertently deleting Raw Data sheet but still
be able to change it. I tried various protection schemes but couldn't get
protection to allow copying another sheet into protected sheet.
Is it possible to have this level of protection? I use OfficeXP through 2007.
Any suggestions would be greatly appreciated!
program. Data are copied to a hidden sheet where data are cleaned up for use
by macros. Whenever user changes Raw Data sheet the program offers user
option of updating the hidden sheet. Sometimes updates are just changing a
few cells but often the complete sheet is pasted in.
I need to prevent user from inadvertently deleting Raw Data sheet but still
be able to change it. I tried various protection schemes but couldn't get
protection to allow copying another sheet into protected sheet.
Is it possible to have this level of protection? I use OfficeXP through 2007.
Any suggestions would be greatly appreciated!