Hide Sheet Tabs using VBA / Hide Excel Sheet Tabs (2007/2010)

Submitted by Support on Sat, 08/21/2010 - 13:04

How to Hide Excel Sheet Names using VBA

If you want to hide the Sheet Tab (as shown below) you can do that using Excel Options
Hide / Unhide Sheet Tab using Excel VBA
Uncheck the Show sheet tabs checkbox from Advanced Tab of Options Menu
Hide / Unhide Sheet Tab using Excel VBA
You can do the same through Excel VBA

ActiveWindow.DisplayWorkbookTabs = False