View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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