Autofilter issue using macro when locking worksheets

[rajiraji]

Hi,

I've been browsing the forum and found a similar concern but didn't get any result.

i have a macro that locks my worksheets yet it Enables AutoFilter for all the sheets with filtering.
when testing the worksheets - it allows me to use the Filter.
but after re-launching the excel file -- the filter button is there but it won't allow me to click on it.
my sheets are still locked like i wanted it but the autofilter fails.

Below is the code i used --- dragged and tracked around the web

Please Login or Register  to view this content.

Thank you in advance,