Forum Discussion
Doc441
Apr 03, 2020Copper Contributor
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?
Riny_van_Eekelen
Apr 03, 2020Platinum Contributor
Doc441 You need a small piece of VBA code for that. Create your checkbox, right-click it and select "Format Control..." and select the Cell Link (for example A1) and OK. Right-click again and "Assign Macro...". Now you select the macro that does the hiding and unhiding. Example below:
Sub Macro1()
Dim HideSheet As Boolean
HideSheet = Range("A1")
If HideSheet Then
Sheets("Sheet1").Visible = False
Else
Sheets("Sheet1").Visible = True
End If
End SubThis code assumes you have a check box linked to A1. It will hide "Sheet1" when ticked, and unhide it when not ticked. The attached workbook contains a working example.
Doc441
Apr 03, 2020Copper Contributor
Thank you so much