How to Hide Sheet Tabs when workbook Opens

[Murphybp2]

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]

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