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
Using "sort" in auto filter not possible when protected? 0
MS Excel 2003 - Autofilter for protected cells 1
Sorting whole Protected 2003 REDUX 0
Sorting while protected - this question may not have been covered. 1
Utilizng full AutoFilter features while specific cells are protect 0
Comments in protected cells with AutoFilter switched on 3
Autofilter does not work on protected w/s even when "checked to allow" ?? 6

Top