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?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,786
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:

Watch MrExcel Video

Forum statistics

Threads
1,102,554
Messages
5,487,527
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top