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)
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:
ThisWorkbook:
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!
Bookmarks