Can you create a checkbox that will hide or show a tab in a worksheet?

Question

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 · Answer

Doc441&nbsp;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 Sub&nbsp;This 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 · Answer

Thank you so much

lewis-h · Answer

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.

doc441 · Answer

Riny_van_Eekelen&nbsp;Thanks for the reply....I would call myself an intermediate user but the coding seems to be an issue.I am unsure of the HideSheet = Range("A1") component....Thats the line that seems to be erroring.&nbsp;I appreciate your guidance&nbsp;

riny_van_eekelen · Answer

Doc441&nbsp;Can't really tell. It works fine in my file. What error message do you get?

Forum Discussion

Can you create a checkbox that will hide or show a tab in a worksheet?

7 Replies

Resources