X
X
Is it possible to unhide more than one hidden worksheet at
a time?
a time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
in code (just recorded) to HIDE. =True to UNHIDE
Sub Macro4()
'
' Macro4 Macro
' Macro recorded 9/30/2003 by Don Guillett
'
'
Sheets(Array("Sheet6", "Sheet9")).Select
Sheets("Sheet9").Activate
ActiveWindow.SelectedSheets.Visible = False
End Sub
Sub Macro4()
'
' Macro4 Macro
' Macro recorded 9/30/2003 by Don Guillett
'
'
Sheets(Array("Sheet6", "Sheet9")).Select
Sheets("Sheet9").Activate
ActiveWindow.SelectedSheets.Visible = False
End Sub
D
Don Guillett
Sorry, What I gave will hide. You must un-hide thusly:
myarray = Array("Sheet6", "sheet9")
For Each sh In Sheets
sh.Visible = xlSheetVisible
Next
myarray = Array("Sheet6", "sheet9")
For Each sh In Sheets
sh.Visible = xlSheetVisible
Next
V
Vasant Nanavati
Hi:
Only by writing your own macro. I have written one that I can send you if
you like.
Regards,
Vasant.
Only by writing your own macro. I have written one that I can send you if
you like.
Regards,
Vasant.
X
X
Works great! I have approx. 45 worksheets to unhide each
month. Thanks a lot.
month. Thanks a lot.