Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide and unhide worksheets
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide and unhide worksheets
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 --- Regards, Norman "Profairy " wrote in message ... Hi people, i'm having problems here. I wanted to hide all the worksheet tabs when i opened the workbook and managed to do that but now i don't know how to unhide them and i've lost the original macro so i don't know the command i originally used... doh! Ok, firstly i need to show all workbook tags again... how do i unhide them? secondly i want the workbook to open with sheet 1 visible and the others hidden. can anyone help me... Helen x --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide and unhide worksheets
Just to add, optionsviwetabs
to manual show hide all tabs. Helen you don't work for cereform do you??? Ross |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide and unhide worksheets
cereform? - no hehehe
Thanks for the advice every one!! I got that working.. -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide worksheets upon entries in a range of the main worksheet | Excel Discussion (Misc queries) | |||
Hide/Unhide row VBA | Excel Discussion (Misc queries) | |||
Hide/Unhide | Excel Discussion (Misc queries) | |||
How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
Hide/Unhide worksheets help | Excel Programming |