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
- 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