Sheet protection; can't use AutoFilter

[malik641]

I want to protect a sheet, but I want to still be able to use the
AutoFilter. How would I do this? Do I have to unprotect the cells that
are in the AutoFilter range?

Any help is highly appreciated.
Thanks.

 

[dominicb]

Good afternoon Malik641

You can use an autofilter on a protected page, but Excel won't do it
automatically for you - you need to tell it how to do it. Debra
Dalgleish has an article that discusses it here :

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

HTH

DominicB

 

[malik641]

Well, it's "Good Morning" for me, it's 10:30AM

But anyway, Good afternoon Dominic!
Thanks for the reply! That worked out great!

 

[dominicb]

Hi Joseph

You're welcome. I appreciate the feedback.

DominicB

PS Here in England it's 4.01pm - going home soon. Cool