Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
Multiple worksheets open on starting Excel. | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) |