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