Unhiding Sheets

[Mattlynn via OfficeKB.com]

Hi All

Is there a way, you can unhide more than 1 worksheet at a time
You seem to be able to hide as many as you like, by selecting sheets and then
hiding, but i cant find a quicker way to either unhide all, or unhide
specific sheets.

Please help.

Many Thanks
Matt

 

[Max]

Try the sub below to unhide all sheets, taken from a post by macropod:


Sub ShowAllSheets
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Visible = True
Next
End Sub

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik

 

[Mattlynn via OfficeKB.com]

Thats Great Max - thanks
Matt

Try the sub below to unhide all sheets, taken from a post by macropod:

Sub ShowAllSheets
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Visible = True
Next
End Sub

Hi All

[quoted text clipped - 8 lines]

Many Thanks
Matt

 

[Max]

Welcome, Matt
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik