Sheet protection; can't use AutoFilter
 

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.


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=389041

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389041

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

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

dominicb Wrote:
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


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=389041

Hi Joseph

You're welcome. I appreciate the feedback.

DominicB

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389041