Hello everyone, this is my first post..
I had written this code to show/hide worksheets based on check box of worksheet names.
If the check box corresponding to a sheet says TRUE, the particular sheet is shown whereas the sheet is hidden if it is false.
Problem: When I open the workbook and select a few sheets (corresponding check boxes) and press the button linked to this code, it works fine (and shows the selected sheets) but on further iterations (when I change the check boxes) it does not work (does not change the visibility of sheets) till I close and reopen the workbook.
Program:
Expectation:
I should be able to refresh the selection and choose a different set of sheets.
Regards,
Kavindra
Bookmarks