Ginnesa Redding
asked on
collapsing/expanding a group of spreadsheets
I have a large number of spreadsheets in my excel file. I would like to be able to take a group of the spreadsheets and minimize them so that it is easier to separate them into groups. Is that possible to do in excel? Thanks for your help!
In Excel you can only minimize a window and so unless you have more that one window open you won't be able to see any sheets after minimizing the one window. You could however easily add code to hide certain sheets.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And to unhide them.
Sub UnHideSomeSheets()
Dim ws As Worksheet
For Each ws In Worksheets
Select Case ws.Name
Case "Sheet1", "Sheet2"
ws.Visible = xlSheetVisible
End Select
Next
End Sub
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.