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

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. ActiveWindow.DisplayWorkbookTabs = False

    ReplyDelete

StumbleUpon
Share on Facebook
Related Posts Plugin for WordPress, Blogger...

Visual Basic for Applications (VBA) Forum (recent threads)

CodeKeep VBA Feed

Visual Studio Tools for Office Forum (recent threads)

Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.

Office Business Applications (OBA) Team Blog

MSDN Code Gallery Published Resources For Tag VSTO

microsoft.public.vsnet.vstools.office Google Group