i found this post here
now how can i make this a toggle?
Private Sub Worksheet_Deactivate()
ThisWorkbook.Sheets(Array("Sheet3", "Sheet4", "Sheet5", "Sheet6")).Visible = False
End Sub
so start with an if statement:
Private Sub Worksheet_Toggle()
if sheet3.visible = True then
ThisWorkbook.Sheets(Array("Sheet3", "Sheet4", "Sheet5", "Sheet6")).Visible = False
else
ThisWorkbook.Sheets(Array("Sheet3", "Sheet4", "Sheet5", "Sheet6")).Visible = True
not sure of the terminology on the IF statement, but once that is figured out, it should work, right?
thanks for your help.
Bookmarks