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!
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!