If you want to hide the Sheet Tab (as shown below) you can do that using Excel Options
Hide / Unhide Sheet Tab using Excel VBAUncheck the Show sheet tabs checkbox from Advanced Tab of Options Menu
Hide / Unhide Sheet Tab using Excel VBAYou can do the same through Excel VBA
ActiveWindow.DisplayWorkbookTabs = False
Saturday, August 21, 2010
Hide Sheet Tabs using VBA / Hide Excel Sheet Tabs (2007/2010)
How to Hide Excel Sheet Names using VBA
You can do the same through Excel VBA
You can do the same through Excel VBA
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
Was looking a long time for this one. Most tips & tricks I saw explained how to set XlSheetVisibility. Thanks a lot!
ReplyDeleteis this a joke!!!! oh men .. . im looking for the codes dude!!!
ReplyDeleteHow can a command so simple be so hard to find on-line?
ReplyDeleteIsn't it just worksheet("Nameofsheet").Visible = True OR False ??????
Hi,
ReplyDeletewhat you're looking for is (in full)
Thisworkbook.sheets("SHEETNAMEHERE").visible = xlHidden
ActiveWindow.DisplayWorkbookTabs = False
ReplyDelete