Checkbox Controls and Worksheet(tabs) visibility

[gemcgraw]

I am trying to control the visibility of tabs in a workbook based on what Checkbox is "checked" on the first worksheet. AND, if the checkbox is checked, there is a minimal data requirement (i.e. row#) on that sheet before it will allow you to close the file -or- leave the tab. In my mind I can see the logic but I can't vision or grasp the actual coding required within Excel.

 

[Paradigm_Shift]

To change between sheets, use a version of this:

Sub CheckBox1_Click()
    On Error GoTo NoSheetFound
    Sheets("Sheet1").Activate
NoSheetFound:
    Exit Sub
End Sub

However, I would suggest using option buttons instead...

 

[gemcgraw]

Actually, I'm not needing a "hyperlink" to navigate to the tabs. My problem and goal is to hide/show tabs based on what control boxes are "checked" on tab1. Example: I have a workbook with 20 tabs (worksheets). Tab1 is my "control" tab that has the control "Checkboxs". Tabs 2-20 are invisible. When Checkbox1 is "checked" Tab2 becomes visible, etc.