Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Unhide command?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I can "Step Into" my macros, but cannot "Edit" them. I get a message: "Cannot edit a macro on a hidden workbook. Unhide the workbook using the unhide command". The help menu doesn't say anything about the Unhide Command.
    What does hidden mean and how can I unhide it?
    Thanks.
    Ron S

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    From your Window menu in Excel (not the VB Editor), choose Unhide.


    ~Anne Troy

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On your toolbar , on the window menu, there is a hide and unhide command . Check the unhide command and see if you have a hidden workbook if you do unhide it with the unhide command.

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-04 22:10, Dreamboat wrote:
    From your Window menu in Excel (not the VB Editor), choose Unhide.


    Hi Dreamboat,
    Thank you for your reply. I chose Unhide but now all my macros are gone. What gives? I would like to be able to print a macro but can't from Step Into.
    Cables

  5. #5
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cables, are you familiar with the VB Editor window?

    At the top-left you'll see a *browsing* window that's a lot like Windows Explorer. On the *first level*, you should see your file, and also any hidden files that you've *unhidden* by going to Window menu in the Excel workbook view and choosing Unhide.

    If you are not familiar with hidden Excel files, and you're doing VBA, then you should be.

    When you create a macro to be used in ALL files, Excel automatically creates a file called personal.xls. This file is stored in your XLSTART directory. It is also hidden. Other than that, it's an Excel file like any other.

    Launch Excel with NO files open. Hit Window on the menu. Hit Unhide. Are you given any file names? At this point, it seems this would be your first step.
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •