brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a protected worksheet which I want to enable staff to view and to even filter date (Using drop down filter in headings). However, I want to prevent staff from changing any data on the sheet and I have to unprotect the worksheet to run the filter. Is there any way of doing this in a way that staff cannot change data on the sheet. I do run a macro which unprotects the worksheet, enters data onto it and then protects the worksheet again.