Forum Discussion
Can you create a checkbox that will hide or show a tab in a worksheet?
If I create a yes/no button could it trigger the hiding or exposing of an additional tab in the same worksheet?
Use checkbox to hide or unhide worksheet in Excel.
Open the worksheet contains the Checkbox1, right click the sheet tab, and then click View Code from the right-clicking menu.
Note: The check box should be ActiveX check box when you inserting.
Open the worksheet contains the Checkbox1, right click the sheet tab, and then click View Code from the right-clicking menu.
Note: The check box should be ActiveX check box when you inserting.