How do you unhide multiple sheets?

hrelden3

New Member
Joined
Nov 14, 2019
Messages
4
I hid a lot of sheets, now I seem tho have to unhide them one by one. Is there a btter way?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,476
Office Version
365
Platform
Windows
Short of using VBA, not that I know of.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,476
Office Version
365
Platform
Windows
This will unhide all sheets in the workbook
Code:
Sub hrelden3()
    Dim Ws As Worksheet
    For Each Ws In Worksheets
        Ws.Visible = xlSheetVisible
    Next Ws
End Sub
 
Last edited:

Forum statistics

Threads
1,078,342
Messages
5,339,652
Members
399,318
Latest member
kryten68

Some videos you may like

This Week's Hot Topics

Top