[SOLVED] How to Hide Sheet Tabs when workbook Opens

[Murphybp2@gmail.com]

I have a shared workbook that I manage. Users navigate through the
workbook with the links that I built. So I hide the sheet tabs so that
they have to use the built navigation. But when I am making changes or
adding things to the workbook, I show the sheet tabs because I may need
to do something that requires they be visible. But sometimes I forget
to hide them again. What VBA code could I put into the This Workbook
module to automatically hide the sheet tabs when the workbook is opened?

[Paul W Smith]

Try:

ActiveWindow.DisplayWorkbookTabs = False

HTH

Paul Smith


<Murphybp2@gmail.com> wrote in message
news:1141838047.585487.142200@i40g2000cwc.googlegroups.com...
>I have a shared workbook that I manage. Users navigate through the
> workbook with the links that I built. So I hide the sheet tabs so that
> they have to use the built navigation. But when I am making changes or
> adding things to the workbook, I show the sheet tabs because I may need
> to do something that requires they be visible. But sometimes I forget
> to hide them again. What VBA code could I put into the This Workbook
> module to automatically hide the sheet tabs when the workbook is opened?
>

[Murphybp2@gmail.com]

That did it. Thanks. Couldn't figure it out.