Forum Discussion
Macro for clearing filters on a protected sheet
I have an Excel file that I need to clear the filters from a column on a password protected sheet. When someone opens the shared file (from OneSite), I would like for the filters in 2 of the columns...
Thank you so much for your help on this and it is so close to what I need but it unclicks the auto filter when the protection is put back but I need the auto filter to be on when the file opens. Can you add that to this for me?
Here is the code when opening the file.