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.

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.

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.

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.

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.