Autofilter in protected worksheet

[Gustavo]

Hi everyone,
Does anybody know how to have a working autofilter in a
protected worksheet? I work with Excel 2000
Thanks in advance
Gustavo

 

[Frank Kabel]

Hi
not sure but I think enabling Autofilter for protected sheets was
introduced with Excel 2002. In your case you have to unprotect the
worksheet prior to this (within a macro). See:
http://www.contextures.com/xlautofilter03.html#Protect

 

[Dave Peterson]

It was added in xl2002, but Debra's Dalgleish's code actually protects the
worksheet in a special way that allows the use of the existing autofilter
dropdowns.

This is the top secret portion in Deb's code:
....,UserInterfaceOnly:=True