Link to home
Start Free TrialLog in
Avatar of Ginnesa Redding
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!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial