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]

NO. and please do NOT multipost

 

[Debra Dalgleish]

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

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

 

[Rob_T]

Can anyone help me with this please, I have a similar problem.

I want to do exactly the same thing (protect the worksheet but hav
autofiltering functional) but be able to unprotect it to run a macr
and then re-protect it again at the end.

I've got this line of code in my macro at the end but it doesn't see
to recognise the "UserInterfaceOnly" part:

ActiveSheet.Protect Password:="*********", _
DrawingObjects:=True, Contents:=True, _
userinterfaceonly:=True

As you can see, it hasn't put the capitals in the "UserInterfaceOnly
implying that it hasn't recognised it.

Any help would be greatly appreciated.

Cheers,

Ro

 

[Rob_T]

Never mind, I got it to work after a bit (lot) of fiddling

Ro