Thursday, August 4, 2011

Hide / Unhide Sheet Tab using Excel VBA

If you want to hide the Sheet Tab you can do that using Excel Options

1) Uncheck the Show sheet tabs checkbox from Advanced Tab of Options Menu.
2) Go to the advanced tab and you can enable/disable through the show sheet tabs options.


You can do the same through Excel VBA

ActiveWindow.DisplayWorkbookTabs = False

1 comment:

eddyshaw9272711 said...

After study a number of of the weblog posts on your web site now, and I actually like your manner of blogging. I bookmarked it to my bookmark website checklist and can be checking back soon. Pls take a look at my website as effectively and let me know what you think. casino online