Hi All,
I asked the question in the past on how to create two buttons so that I can have a data entry specific protection and then a lock all button. Here's the link to the thread:
http://www.excelforum.com/excel-prog...-a-button.html
And here's the code I'm currently using:
Is there anyway that this can be adapted so that when the sheet is "Lock All" protected or if it's "Data Entry" protected that they can still use the filter?
I've been looking on the site a bit, but haven't had any luck finding anything.
Thanks for your help!
Bookmarks