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


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=504982