Can I protect but allow filtering ?

L

lynn

I want to lock a file, but allow users to use Autofilter.
I dont see an option to do this in Excel 2000, but in
2002, I went to Tools - Protection - Protect Sheet, and
selected "allow users to use autofilter", but autofilter
is still greyed out.

Can this be done ?
 
Top