![]() |
Protect sheet but allow user paste
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! |
All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com