Hide/Unhide a Group Of Sheets

[BPtexan]

I really show know this one, but I can't figure it out.

I'm trying to group show / hide sheets based on a toggle button on a page. I have other hidden sheets that I want to keep hidden, but I have 15 sheets that I need to toggle back & forth.

sheets("sheet1").visible = true -- works fine
sheets("sheet1","sheet2").visible = true -- doesn't work
sheets(array("sheet1","sheet2")).visible = true -- doesn't work

I get a 1004 error unable to set the visible property of the sheet class group.

I know there's a simple fix, but I'm not sure what it is. Thanks!

 

[jbeaucaire]

To do multiple sheets, this one macro will toggle the sheets visible/invisible with one code:

Option Explicit

Sub ToggleSheetsVisibility()
Dim ws As Worksheet

    For Each ws In Sheets(Array("Sheet1", "Sheet2"))
        ws.Visible = (ws.Visible = False)
    Next ws

End Sub