Allow Auto Filter in Protected Sheet

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi all

I'm having a protected sheet and a protected range of cells, I checked
"Allow Auto-Filter", but the Auto Filter button is disabled, How can I
protect cells of changing it's value but still be able to use auto filter on
the protected cells ?.

Any help will be greatly appreciated

Simon
 
That setting will allow users to apply filters to a table where the
AutoFilter is already turned on. However, they won't be able to create a
new AutoFilter on the sheet.
 

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

How do I protect a range but allow auto filtering in earlier versi 1
Macro to allow auto filter after running password protect 1
Help with using Auto-filter in a protected Worksheet. 5
Allow users of protected sheet to use macro involving custom filte 3
Sorting in a protected sheet 1
ProtectSheet Options are un-checking after macro 9
Filtering on a protected Sheet 2
Protcting a worksheet with a filter 4

Back
Top