Autofilter & Protection

[Ukmopar]

Hi,

I use autofilter to filter out rows with results that are
zero. When I protect the sheet to stop the formulae being
changed, autofilter is no longer available. I've tried
excluding the column where the filter works from the
locked area. No joy.

Does anyone have any suggestions please.

Thanks

 

[Paul B]

Ukmopar, have a look here
http://www.contextures.com/xlautofilter03.html#Protect

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **