| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unhide Multiple Sheets At One Time?
Currently I have to unhide each sheet one at a time. Is it possible
to unhide multiple sheets all at one time? Please advise. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhide Multiple Sheets At One Time?
You could do it with VBA code, initiated by a pushbutton toggle to
hide/unhide them. Vaya con Dios, Chuck, CABGx3 "Sweepea" wrote: Currently I have to unhide each sheet one at a time. Is it possible to unhide multiple sheets all at one time? Please advise. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhide Multiple Sheets At One Time?
Sub visible_sheets()
Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In ActiveWorkbook.Sheets sht.Visible = xlSheetVisible Next sht Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 11:42:00 -0800, CLR wrote: You could do it with VBA code, initiated by a pushbutton toggle to hide/unhide them. Vaya con Dios, Chuck, CABGx3 "Sweepea" wrote: Currently I have to unhide each sheet one at a time. Is it possible to unhide multiple sheets all at one time? Please advise. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhide Multiple Sheets At One Time?
Thank you so much, Gord. It works!
"Gord Dibben" wrote: Sub visible_sheets() Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In ActiveWorkbook.Sheets sht.Visible = xlSheetVisible Next sht Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 11:42:00 -0800, CLR wrote: You could do it with VBA code, initiated by a pushbutton toggle to hide/unhide them. Vaya con Dios, Chuck, CABGx3 "Sweepea" wrote: Currently I have to unhide each sheet one at a time. Is it possible to unhide multiple sheets all at one time? Please advise. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unhide Multiple Sheets At One Time?
Thanks for the feedback.
Gord On Fri, 5 Jan 2007 12:35:00 -0800, Sweepea wrote: Thank you so much, Gord. It works! "Gord Dibben" wrote: Sub visible_sheets() Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In ActiveWorkbook.Sheets sht.Visible = xlSheetVisible Next sht Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 11:42:00 -0800, CLR wrote: You could do it with VBA code, initiated by a pushbutton toggle to hide/unhide them. Vaya con Dios, Chuck, CABGx3 "Sweepea" wrote: Currently I have to unhide each sheet one at a time. Is it possible to unhide multiple sheets all at one time? Please advise. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| Time sheets | Excel Worksheet Functions | |||
| CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME | Excel Discussion (Misc queries) | |||
| Excel: Enable UnHiding of multiple sheets at once | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Hybrid Mode
