Help wanted for Advanced filter/sheet protection

K

Kathrine

I have several sheets using advanced filter to display data :
- automatically when you enter the sheet
- or upon change of any input criteria

I want to protect the sheet(s), have already unlocked the appropriate cells
(criteria -range only).
Then Tools - protection - sheet protection - allow autofiler

But the filter will no longer run... Does the checkbox (autofilter) in
Protection dialog box not apply to advanced filter, or am I doing something
wrong ?

I suspect I have to switch protection off and on before and after every
filteraction in the code...?

Any advise will be much appreciated
 

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