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.
 
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!
 
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?
Click to expand...
 

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

Similar Threads

MS Excel 2003 - Autofilter for protected cells 1
Using Autofilter on Protected sheets 3
Sorting while protected - this question may not have been covered. 1
Autofilter does not work on protected w/s even when "checked to allow" ?? 6
Autofilter not working on protected sheet. 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Bug re Protect a worksheet 1
How to Sort within AutoFilter with Protection on (and AutoFilter . 1

Top