Pages

▼

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

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
at

5 comments:

  1. kristof4:46 AM

    Was looking a long time for this one. Most tips & tricks I saw explained how to set XlSheetVisibility. Thanks a lot!

    ReplyDelete
  2. Anonymous9:09 PM

    is this a joke!!!! oh men .. . im looking for the codes dude!!!

    ReplyDelete
  3. Anonymous12:35 PM

    How can a command so simple be so hard to find on-line?

    Isn't it just worksheet("Nameofsheet").Visible = True OR False ??????

    ReplyDelete
  4. Anonymous5:56 AM

    Hi,
    what you're looking for is (in full)
    Thisworkbook.sheets("SHEETNAMEHERE").visible = xlHidden

    ReplyDelete
  5. Roy Cox5:56 AM

    ActiveWindow.DisplayWorkbookTabs = False

    ReplyDelete