How to Hide Sheet Tabs when workbook Opens
 

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?

How to Hide Sheet Tabs when workbook Opens
 

Try:

ActiveWindow.DisplayWorkbookTabs = False

HTH

Paul Smith


wrote in message
oups.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?

How to Hide Sheet Tabs when workbook Opens
 

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