Using Autofilter with Protection on

[Duncan Help]

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