AutoFilter 2003 Excel Protected Sheet


G

Guest

I followed instruction to protect sheet and allow autofilter but still Excel
2003 sheet will not give me option to autofilter.

I used tools, protection, protect sheet. Next I selected Use AutoFilter and
clicked OK. But the only thing it allows me to do is Advanced Filter.

Is there something else I have to change that may be set wrong by default
somewhere? I know this should work.
 
Ad

Advertisements

D

Dave Peterson

The worksheet already has to have the autofilter arrows applied when you protect
the sheet.

Could that have been your problem?
 
G

Guest

Yes, I have made sure that all cells are not locked as well as I have got
sort to work when protected.

Still no luck on Autofilter!
 
Ad

Advertisements

G

Guest

That was it.

Thank You.
--
Brian


Dave Peterson said:
The worksheet already has to have the autofilter arrows applied when you protect
the sheet.

Could that have been your problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top