Unprotect Auto Filters

[Gordon]

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

[dominicb]

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