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.

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Oct 26, 2024

steve_2931 

Hide the Worksheet Tabs with out VBA:

Go to the File menu in Excel.

Select Options.

In the Excel Options dialog box, go to the Advanced section.

Scroll down to the Display options for this workbook.

Uncheck the box that says Show sheet tabs.

Click OK.

 

Hide the Worksheet Tabs with VBA:

You can add a macro that re-hides the tabs if a user tries to unhide them:

Private Sub Workbook_Open()

    Application.CommandBars("Workbook Tabs").Visible = False

End Sub

This code will run whenever the workbook is opened, ensuring the tabs remain hidden. However, it requires enabling macros.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

steve_2931's avatar
steve_2931
Copper Contributor
Oct 26, 2024
Thank you, I am away for a few days but will give this a go when I return. Thank you for taking the trouble to reply. Regards Steve

Resources