Unprotect Auto Filters
 

Hi...

I need a sheet fully protected but need the user to have access to the Auto
Filters...how can I do this. Simple but beyond me!

grateful for any help...

Gordon

Unprotect Auto Filters
 

Good afternoon Graham

If you are using Excel 2002 or later you can specify when protecting
the sheet whether filters can be acivated or not.

If you have Excel 97/2000 then Debra Dalgleish has an elegant solution
to this on her site:

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=480096