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?

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?

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