Excel Filters

[Harold H]

I need to know how to make my filter work when my sheet is
protected. My filter works fine as long as my sheet is NOT
protected, but when I protect my sheet, my filter won't
work. Is there any way to make a filter work when the
sheet is protected? I have Excel 2000.
I need help from anybody.
Thanks

 

[Don Guillett]

see ans in worksheetfunctions.

 

[Debra Dalgleish]

As answered in microsoft.public.excel.worksheet.functions:

'==============================
There are instructions here for allowing filtering on a protected
worksheet:

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

 

[Earl Kiosterud]

Harold,

What Don and Debra are trying to tell you nicely is not to post the same
question in more than one group. It can cause multiple responses that waste
the responder's time. That's all.