| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need code for hiding/unhiding sheets using checkboxes | Excel Worksheet Functions | |||
| Unhiding multiple sheets at a time | Excel Discussion (Misc queries) | |||
| Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
| Unhiding Sheets | Excel Discussion (Misc queries) | |||
| Excel: Enable UnHiding of multiple sheets at once | Excel Discussion (Misc queries) | |||
Hybrid Mode
