Using Autofilter on a protected sheet

[John]

When I protect a worksheet in Excel 2000 (with SP-3
loaded) the Autofilter function doesn't work. The arrows
are visibile at the top of the selected cells, but I can't
open the drop-down lists. The Autofilter has been created
on a range of cells that are NOT locked. Does anybody
know if there is a way around this problem?

 

[Debra Dalgleish]

If you protect the worksheet programmatically, you can use the
AutoFilter. There are instructions here:

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