Using Autofilter with Protection on

[Guest]

I have put protection of a worksheet, and Autofilter checkbox is on, but the
Autofilter option in Data Filter is greyed out. What am I doing wrong?

 

[dominicb]

Good afternoon Duncan Help

Probably nothing. If you are using Excel 2002 or later you can set the
options when you turn on the protection whether or not to allow the
filters to operate.

If you are using XL2000 or prior you don't have that luxury.
Fortunately, Debra Dalgleish has an elegant solution to the problem
here:

http://www.contextures.com/xlautofilter03.html#Protect

HTH

DominicB