Excel: Enable UnHiding of multiple sheets at once
 

When you have multiple sheets hidden in workbook and want to unhide more tha
one, you must go back thru the dialog box to unhide each. Why not write this
one to be like most others so you can shift-click/ctrl-click the sheetnames
you want to unhide while you're ther ONCE and unhide them all at one time?

Cyber

http://register.microsoft.com/mswish/suggestion.asp

While waiting for MS to make the changes in the next version you could use a
macro.

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub


Gord Dibben Excel MVP

On Thu, 13 Jan 2005 11:33:02 -0800, "CyberTaz"
wrote:

When you have multiple sheets hidden in workbook and want to unhide more tha
one, you must go back thru the dialog box to unhide each. Why not write this
one to be like most others so you can shift-click/ctrl-click the sheetnames
you want to unhide while you're ther ONCE and unhide them all at one time?