How do I open multiple hidden worksheets all at once?
 

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?

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?

Why is this giving me an error? It doesn't make sense!!!!

SUMPRODUCT(--('Raw - 2nd'!$C$2:$C$65536=$A37),--(MONTH('Raw -
2nd'!$b$2:$b$65536=4),'Raw - 2nd'!$J$2:$J$65536)

Column c is employee number
Column b is date range
Column j is $$ range

Any help is appreciated. Hopefully I have not broken any rules by jumping
in this string

"Gord Dibben" wrote:

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?