How to use checkbox to hide or unhide worksheet in Excel?
Checkbox is a useful feature in Excel. Here I will show you how to use a checkbox to hide or unhide a specified worksheet in Excel.
Supposing you have a checkbox named checkbox1 in your workbook. When unchecking this checkbox, you want a certain worksheet to be hidden automatically in this workbook, and unhide this worksheet while checking the checkbox. Please achieve it as follows.
1. 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.
2. In the Microsoft Visual Basic for Applications window, please copy and paste the below VBA code into the Code window. See screenshot:
VBA code: Use checkbox to hide or unhide specified worksheet
Private Sub CheckBox1_Click() On Error Resume Next ThisWorkbook.Sheets("Sheet5").Visible = CheckBox1.Value End Sub
Note: In the code, Sheet5 is the name of the worksheet you will hide or unhide with checkbox1. Please replace the worksheet name as you need.
3. Press Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.
From now on, when unchecking the checkbox1, the specified worksheet “Sheet5” will be hidden automatically. And you can show it by checking the checkbox. See screenshot:
- How to filter data based on checkbox in Excel?
- How to hide checkbox when row is hidden in Excel?
- How to create a drop down list with multiple checkboxes in Excel?
- How to highlight cell or row with checkbox in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!