Unhiding Sheets
 

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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200808/1

Unhiding Sheets
 

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" <u44078@uwe wrote in message
news:88da907cc0252@uwe...
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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200808/1

Unhiding Sheets
 

Thats Great Max - thanks
Matt

Max wrote:
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

--
Matt Lynn

Message posted via http://www.officekb.com

Unhiding Sheets
 

Welcome, Matt
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:88dbc63405e1a@uwe...
Thats Great Max - thanks
Matt