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