Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Tabs
Does anyone know the easiest way to hide and unhide un-used tabs in an
Excel worksheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Tabs
Without computer programming, you can simply select the sheet that you want
to hide, click on Format in the toolbar, Sheet, then Hide. To Unhide a hidden sheet, from any sheet, go to Format-Sheet-Unhide and you will be given a list of sheets to unhide, select the desired sheet and unhide it. Programmatically, there are two versions of hide, one that will allow you to unhide it using the method above, the other to prevent unhiding it... Then unhide would be setting the hidden property of the worksheet to visible. Values for visible are -1, 0, and 2. So Sheet1.visible = -1 makes the sheet visible Sheet1.Visible = 0 makes it simply hidden and be unhidden by the method above. Sheet1.Visible = 2 makes it very hidden, where it can not be unhidden but by the program (not the user) unhiding the sheet. So take your pick, I think you asked for easiest, which was the first answer. :) "jdawg" wrote: Does anyone know the easiest way to hide and unhide un-used tabs in an Excel worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding tabs for just some sheets. | Excel Worksheet Functions | |||
Hiding Tabs | Excel Discussion (Misc queries) | |||
Hiding Rows & Tabs at the same time | Excel Discussion (Misc queries) | |||
Hiding Tabs | Excel Programming | |||
Hiding Tabs | Excel Programming |