Showing posts with label Hide / Unhide Sheet Tab using Excel VBA. Show all posts
Showing posts with label Hide / Unhide Sheet Tab using Excel VBA. Show all posts

Saturday, August 21, 2010

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

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


Uncheck the Show sheet tabs checkbox from Advanced Tab of Options Menu


You can do the same through Excel VBA

ActiveWindow.DisplayWorkbookTabs = False
Related Posts Plugin for WordPress, Blogger...
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.