H
harpscardiff
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
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