Last

VBA 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, 14 Jul 2005 13:18:15 -0700, Last Samurai <Last
wrote:

I know how to hide multiple worksheet by tagging them. How do you open
multiple worksheets all at once rather than having to do them individually?