karthik_kaliappan
Board Regular
- Joined
- Jun 8, 2007
- Messages
- 76
Hi,
Sub Hideall()
Sheets(Array("Sheet2", "Sheet3")).Select
Sheets("Sheet1").Activate
ActiveWindow.SelectedSheets.Visible = False
End Sub
i wrote a simple macro to hide couple sheets leaving the first sheet, but i was looking for a macro which would probably hide all the sheets leaving the fisrt one, but was kind off confused what coding should i give. Could any one help me with this please?
Rgds,
karthik.
Sub Hideall()
Sheets(Array("Sheet2", "Sheet3")).Select
Sheets("Sheet1").Activate
ActiveWindow.SelectedSheets.Visible = False
End Sub
i wrote a simple macro to hide couple sheets leaving the first sheet, but i was looking for a macro which would probably hide all the sheets leaving the fisrt one, but was kind off confused what coding should i give. Could any one help me with this please?
Rgds,
karthik.