Hide and unhide worksheets

P

Profairy

Hi people,

i'm having problems here. I wanted to hide all the worksheet tabs whe
i opened the workbook and managed to do that but now i don't know ho
to unhide them and i've lost the original macro so i don't know th
command i originally used... doh!

Ok, firstly i need to show all workbook tags again... how do i unhid
them?

secondly i want the workbook to open with sheet 1 visible and th
others hidden.

can anyone help me...

Helen x:confused
 
N

Norman Jones

Hi Helen,

To unhide the worksheet tabs, Tools | Options | View ! Sheet Tabs

In VBA:

Sub Test
ActiveWindow.DisplayWorkbookTabs = False
End Sub

To hide all but Sheet1 on opening,
right-click the XL icon on the left of the menu bar | View Code and paste
the following into the ThisWorkbook module:

Sub workbook_open()
Dim WS As Worksheet

Sheets("Sheet1").Visible = True
For Each WS In Me.Sheets
If Not WS.Name = "Sheet1" Then
WS.Visible = False
End If
Next
End Sub
 
R

ross

Just to add, options>viwe>tabs
to manual show hide all tabs.

Helen you don't work for cereform do you???

Ross
 
Top