JackyJ
09-24-2010, 03:49 AM
I wish to hide/unhide multiple sheets using a toggle button. What code do I need to add, to the following, to include Sheets 'Day 1' through 'Day 7' in the hide/unhide action?
Private Sub ToggleButton1_Click()
If Sheets("Day 1").Visible Then
Sheets("Day 1").Visible = False
Else
Sheets("Day 1").Visible = True
End If
End Sub
Thanking you
Private Sub ToggleButton1_Click()
If Sheets("Day 1").Visible Then
Sheets("Day 1").Visible = False
Else
Sheets("Day 1").Visible = True
End If
End Sub
Thanking you