Forum Discussion

steve_2931's avatar
steve_2931
Copper Contributor
Oct 25, 2024
Solved

Hiding tabs in excel but retain links to other sheets

Hi, I have created a workbook which has links between each sheet to navigate through the pages. I want to "force" the users to use these links rather than the tabs at the bottom. Is there a way to h...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 26, 2024

    steve_2931 

    If manually you may uncheck this setting

    Please note, it's on workbook basis, not global.

    If by VBA you shall use 

    ActiveWindow.DisplayWorkbookTabs = False

    in macro which NikolinoDE suggested, Application.CommandBars("Workbook Tabs").Visible doesn't work.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 26, 2024

steve_2931 

If manually you may uncheck this setting

Please note, it's on workbook basis, not global.

If by VBA you shall use 

ActiveWindow.DisplayWorkbookTabs = False

in macro which NikolinoDE suggested, Application.CommandBars("Workbook Tabs").Visible doesn't work.

  • steve_2931's avatar
    steve_2931
    Copper Contributor
    Oct 27, 2024
    Thank you Sergei, much appreciated

Resources