Hi,
I have preset filters recorded for different status, so at a click of a button anybody can view pending cases which are at a very high status. But the buttons do not function when I protect the sheet, even though I have selected the Enable AutoFilter box.
Is there any code I can enter to unprotect the sheet then protect the sheet?
Thanks
Bookmarks