There are instructions here for filtering on a protected worksheet:

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

Gordon Cartwright wrote:
Hi...

I want to fully protect my worksheet but when I do this it
prevents the use of auto filters...any ideas? I want a
fully protected sheet and auto filters that can be used...

Thanks in advance

Gordon,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html