I need to be able to protect all the cells on a sheet from being amended but I also need the user to be able to filter on 1 coloum , column C. Can this be done
I need to be able to protect all the cells on a sheet from being amended but I also need the user to be able to filter on 1 coloum , column C. Can this be done
If you have 2003 (not sure if 2000 has it), you should have a choice in the Protect Sheet dialogue to allow use of Autofilter..
So go to Tools|Protection|Protect sheet and check Use Autofilter.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
i have 2000 can anyone help ?
You'll have to use VBA:
See here: http://office.microsoft.com/en-us/ex...982701033.aspx
ErrorCodes is the sheet name , however this doesnt workPlease Login or Register to view this content.
it gives me the following message
run time error 424
object required!
Try:
Please Login or Register to view this content.
Got it working needed some more tweeking, whjat a nightmare
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks