Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide xls worksheet tabs (Vista)
Hello,
does anyone know how to hide xls worksheet tabs in Vista Thank you ! Arno |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide xls worksheet tabs (Vista)
Office button (Top left)Excel OptionsAdvanced, see section Display options
for this workbookuncheck Show sheet tabs -- Kind regards, Niek Otten Microsoft MVP - Excel "Arno" wrote in message ... Hello, does anyone know how to hide xls worksheet tabs in Vista Thank you ! Arno |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide xls worksheet tabs (Vista)
Hi
Worksheets("Sheet2").Visible = False Or Worksheets("Sheet2").Visible = xlVeryHidden With the last solution, the user can't make it visible. Thus the only way is to set .visible=true Regards, Per "Arno" skrev i meddelelsen ... Hello, does anyone know how to hide xls worksheet tabs in Vista Thank you ! Arno |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide xls worksheet tabs (Vista)
Thank you so much Niek ! Arno
"Niek Otten" wrote: Office button (Top left)Excel OptionsAdvanced, see section Display options for this workbookuncheck Show sheet tabs -- Kind regards, Niek Otten Microsoft MVP - Excel "Arno" wrote in message ... Hello, does anyone know how to hide xls worksheet tabs in Vista Thank you ! Arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide a worksheet tabs | Excel Worksheet Functions | |||
hide worksheet tabs | Excel Programming | |||
Default tab color for selected tabs in Excel w/ Vista | Setting up and Configuration of Excel | |||
Hide Worksheet Tabs | Excel Discussion (Misc queries) | |||
Hide selected worksheet tabs | Excel Programming |