Autofilter not working on protected sheet.

P

parahumanoid

Is there a way to ensure that autofilter in excel 2007 remains
operable after the sheet protection is enabled.
The cells that are used to set filters' settings are marked as not
protected. However, when I click on the drop-down control nothing
happens. Ideas?

Thanks, folks.
 

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

Enabling Autofilter and Sorting in a Protected Sheet 2
MS Excel 2003 - Autofilter for protected cells 1
Comments in protected cells with AutoFilter switched on 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
Using Autofilter on Protected sheets 3
Autofilter set to "SHOW ALL" on open for a protected worksheet 10
AutoFilter 2003 Excel Protected Sheet 3

Top