How to hide xls worksheet tabs (Vista)
 

Hello,

does anyone know how to hide xls worksheet tabs in Vista

Thank you ! Arno

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

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

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