Hi everyone, I am trying to figure out how to make a macro that will show and hide up multiple tabs in a excel spreadsheet by using a ActiveX Checkbox.   I am able to show a tab by clicking on that designated checkbox.  I need “SHEET 2” checkbox to show “SHEET 3”, “SHEET 4”, and “SHEET 5” once checked, then hide those sheets once it is unchecked.  I tried to add a sheet but it wont accept macro enabled sheets.

​Hi everyone, I am trying to figure out how to make a macro that will show and hide up multiple tabs in a excel spreadsheet by using a ActiveX Checkbox.   I am able to show a tab by clicking on that designated checkbox.  I need “SHEET 2” checkbox to show “SHEET 3”, “SHEET 4”, and “SHEET 5” once checked, then hide those sheets once it is unchecked.  I tried to add a sheet but it wont accept macro enabled sheets.  Read More

​