Filtering with protection enabled

[David]

Is there a way of enabling the auto filter in a protected
worksheet in Excel 2000? The filter works only when
protection is not enabled.
Your help would be gratefully received.
David

 

[Debra Dalgleish]

There are instructions here for filtering on a protected sheet:

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

 

[Guest]

Thanks - its works a treat. The source is also useful for
other Excel tips arranged in alphabetical order
David