Welcome Guest
Log In | Register )
The time is now 4:38 pm
You last visited May 23, 2013, 4:37 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Help Unhide a worksheet

Topic closed. 7 replies. Last post 11 months ago by SergeM.

Page 1 of 1
PrintE-mailLink
Avatar
EAST COAST, USA
United States
Member #49886
January 31, 2007
540 Posts
Offline
Posted: June 14, 2012, 4:22 am - IP Logged

I am trying to edit a macro and I get an error message saying the I need to "unhide" the workbook using the "unhide" command.  Can't seem to get a grip on this? Where exactly do I find the "unhide command?" It's in my Personal Macros Workbook.  Thanks for all your help!

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #5011
    June 3, 2004
    3503 Posts
    Offline
    Posted: June 14, 2012, 5:25 am - IP Logged

    In Excel 07,

    1. On the Home tab, in the Cells group, click Format.

    Excel Ribbon, Home tab, Cells group

    1. Under Visibility, click Hide & Unhide, and then click Unhide Sheet.
    2. In the Unhide sheet box, double-click the name of the hidden sheet that you want to display.

     Note   You can unhide only one worksheet at a time.

      Avatar
      EAST COAST, USA
      United States
      Member #49886
      January 31, 2007
      540 Posts
      Offline
      Posted: June 17, 2012, 6:43 am - IP Logged

      CarBob...you are the One! Thanks a Million! Thank You! Thank You! Thank You!

       

      I have what seems like 500 macros that i need to delete but couldn't because I had to "unhide a worksheet."  The instructions did not say how to unhide it.

        SergeM's avatar - alas

        Aruba
        Member #123712
        February 27, 2012
        1799 Posts
        Online
        Posted: June 17, 2012, 7:10 am - IP Logged

        Press F1 for help.
        Use the macro recorder recommended by Microsoft.

        Take a class Excel programming, you seem not to know the basics.

        Stop breathing!

        .

          Avatar
          EAST COAST, USA
          United States
          Member #49886
          January 31, 2007
          540 Posts
          Offline
          Posted: June 17, 2012, 7:57 am - IP Logged

          Thanks SergeM,

          I'm just a simple user.  I have not really done any programming in Excel.  Not until recently.  But I did buy a course for Excel.  Hopefull this will help.  The only problem with the course is that I know most of the basic stuff.  It's the programming that i am not that familiar with.

            B$Rizzle's avatar - a4leds
            The Ville, FL
            United States
            Member #95908
            August 19, 2010
            1708 Posts
            Offline
            Posted: June 17, 2012, 9:05 am - IP Logged

            Or you can just right click on any tab name and select "Unhide"

              Avatar
              EAST COAST, USA
              United States
              Member #49886
              January 31, 2007
              540 Posts
              Offline
              Posted: June 17, 2012, 9:11 am - IP Logged

              Or you can just right click on any tab name and select "Unhide"

              thanks a bunch B$Rizzle!

                SergeM's avatar - alas

                Aruba
                Member #123712
                February 27, 2012
                1799 Posts
                Online
                Posted: June 17, 2012, 1:00 pm - IP Logged

                Thanks SergeM,

                I'm just a simple user.  I have not really done any programming in Excel.  Not until recently.  But I did buy a course for Excel.  Hopefull this will help.  The only problem with the course is that I know most of the basic stuff.  It's the programming that i am not that familiar with.

                You need to take the advanced course with VBA. It usually is included in a decent course of MS Excel.

                Stop breathing!

                .