Welcome Guest
Log In | Register )
You last visited December 9, 2016, 4:13 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Help Unhide a worksheet

Topic closed. 7 replies. Last post 4 years ago by SergeM.

Page 1 of 1
PrintE-mailLink
Avatar
EAST COAST, USA
United States
Member #49428
January 31, 2007
553 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 #4924
    June 3, 2004
    5912 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 #49428
      January 31, 2007
      553 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 - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        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.

          Avatar
          EAST COAST, USA
          United States
          Member #49428
          January 31, 2007
          553 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 #95879
            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 #49428
              January 31, 2007
              553 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 - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                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.