How to hide Worksheet tab in excel

Have you ever wanted to hide the worksheet tab in your Excel workbook? Perhaps you have sensitive information that you don't want others to see, or maybe you just want a cleaner, more streamlined look for your workbook. Whatever your reasons, you can easily hide worksheet tab in Excel using VBA.

VBA, or Visual Basic for Applications, is a programming language that allows you to automate tasks in Excel. With VBA, you can write code to perform a wide range of actions, including hiding worksheet tab.

 

Here's how to hide worksheet tab in Excel using VBA:

 

Step 1: Open the Visual Basic Editor

To get started, open the Visual Basic Editor in Excel. To do this, press Alt + F11 on your keyboard. This will open the VBA Editor.

 

Step 2: Insert a new module

In the VBA Editor, you'll see a list of your workbook's objects in the Project Explorer window on the left. Double-click on the "Modules" folder to expand it, and then right-click on any module and select "Insert > Module". This will create a new module where you can write your VBA code.

 

Step 3: Write the VBA code to hide worksheet tabs

In the new module, you can write the VBA code to hide worksheet tabs:

Sub Hide_Tabs

  'Hide sheet tabs

    ActiveWindow.DisplayWorkbookTabs = False 

  End Sub

This will hide the worksheet tabs for all the sheets in the workbook.

 

Step 4: Run the VBA code

Once you've written the VBA code, you can run it by clicking the "Run" button on the toolbar, or by pressing F5 on your keyboard. This will execute the code and hide the worksheet tabs.

 

If you want to unhide the worksheet tabs later, you can simply replace “False” with “True”

 

In conclusion, hiding worksheet tabs in Excel using VBA is a simple process that can make your workbook more secure and streamlined. With just a few lines of code, you can automate this task and make your Excel experience even better.