Hi,

would appreciate some help with this please. I have a detailed
spreadsheet with a autofilter so people can choose which lines to
update. I want to protect the worksheet and my formulas from any of the
users changing them. Only when I apply the protection the autofilter
stops working? Any suggestions around it?

I have tried unlocking the cells which contain the filters before
protecting the worksheet, but still doesn't work. Is there a way around
this?
regards
R


--
Wardy1
------------------------------------------------------------------------
Wardy1's Profile: http://www.excelforum.com/member.php...o&userid=27104
View this thread: http://www.excelforum.com/showthread...hreadid=527951