HomeMicrosoft OfficeExcelHow to Hide Worksheet Tabs in Excel VBA?

How to Hide Worksheet Tabs in Excel VBA?

In this post, you’ll learn how to hide the worksheet tabs programmatically in your excel workbook using Excel VBA.

There are times when you might not want to display the Sheet tabs in your Excel workbook. This is usually done by disabling the Sheet tabs in the Excel Tools -> Options -> Advanced.

How to Hide Worksheet Tabs in Excel VBA?

How to Hide Worksheet Tabs Programmatically in Excel VBA?

Below is a sample code snippet that you can use to hide the worksheet tabs for the Active Window using Excel VBA.

Sub HideWorksheetTab()
    ActiveWindow.DisplayWorkbookTabs = False
End Sub

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021