Hide and unhide worksheets

[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

 

[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

 

[ross]

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

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

Ross

 

[Profairy]

cereform? - no hehehe

Thanks for the advice every one!! I got that working..