Hello, I’m kind of a newbie working with VBA.

I’ve built a workbook with multiple password protected sheets.
In order to allow users to open and close groups and use autofilter, I’ve built in the following line of code: (I’ve also added a date imput box)

Please Login or Register  to view this content.
Now I’ve added a toggle button to filter out cells containing zero in 3 sheets. For this I also had to add code to ThisWorkbook to make it work.

ToggleButton1:

Please Login or Register  to view this content.
ThisWorkbook:

Please Login or Register  to view this content.

It all works fine but now, when I open the excel file, the selected cell(s) aren’t highlighted anymore. I’ve noticed that when I select a sheet that isn’t mentioned in the toggle button code and then go back, the selected cell(s) is/are highlighted again.

Is there something wrong with my code or is there a workaround for this problem?
Any help would be much appreciated!