View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Murphybp2@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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?