Hide and Unhide Sheets using Checkboxes

[DallasArosco]

Hello -

Using Excel 2007, I have a workbook with 7 sheets. The first one is a Navigation Page where I have checkboxes (form controls, not active X) with the names of the other 6 sheets. When the box(es) are checked, the sheet(s) become visible. I have accomplished this by assigning macros I recorded.

I need to now add the opposite: When the box(es) are unchecked, the sheets become hidden. From googling and looking for other threads/forums here, I gather that I need to add code/ VBA, but I know nothing about these at all.

Can someone help? Feel free to dumb it down as much as possible. I can upload a copy of my sheet if that helps. Thank you very much in advance.

[Ron Coderre]

Create a new VBA general module for your workbook.
• Select your workbook
• ALT+F11...to open the VBA editor
• Insert.Module...to create a general module

Copy the below code and paste it into that module:

Please Login or Register  to view this content.

• Set the caption of each checkbox to be the name of the sheet to be displayed/hidden
• Assign the ShowHideSheet macro to each checkbox

Now, when a checkbox is clicked...
VBA will note the caption and
- if the checkbox is checked...the sheet will be made visible
- if the checkbox is unchecked...the sheet will be hidden

Is that something you can work with?

[DallasArosco]

That works perfectly. Thank you very much for your help!!