autofilter/outlines blocked on protected worksheets?!

[Stefano Gatto]

Since 9 years (at least), Excel prevents users of
protected worksheets to use outlines or autofilters, even
when these have been set before the worksheet was
protected. Although I still don't understand the rationale
(outlines or autofilters *ARE* read-only features to my
opinion), why doesn't Excel provide the option to exclude
outlines or autofilters from the protection as it does it
for other objects (such as Contents, Objects, Scenarios)?
I am not sure this is the right newsgroup to post such a
question, so disregard it if not.

Thanks.

 

[Jason Morin]

MVP Jim Rech provides the code (for XL97 and XL2000) to
work with autofilters in protected sheets:

http://makeashorterlink.com/?V38021BD5

HTH
Jason
Atlanta, GA