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

Thread: Hiding workbooks

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

    Default

    I'm running Windows NT with Excel 97. Each time I open numerous workbooks, Excel keeps hiding the previously opened ones.

    Any suggestions?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not quite sure what you're saying here.

    Do you want to be able to see more than one book at a time? If so, you'll see two sets of buttons in the top right corner of your screen each has Minimise, Maximise and Close.

    TO see more than one open workbook at a time click on the Maximise button on the lower set of buttons. This switches from full screen view to partial view.

    If your problem is that you want to move between these workbooks, click on "Window" on your toolbar and at the bottom of the menu you will see all of the names of the open workbooks. Simply click on the name of the workbook you want to see.

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

    Default

    The problem is occurring under Window menu. For example, if 5 workbooks are open, Excel will hide 2 of them and only 3 will show up in the list. To display the remaining 2, I have to click the unhide button. It will do this automatically.

    Does this help?

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are there any macros present in these workbooks that woulb cause them to hide upon startup?

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

    Default

    It's actually for a client of mine. I'll have to check with him. He mentioned that it usually does not happen right away. It will occur after he has worked on them for a while. He thought they were hidding due to the large size of the file. Have you ever heard of this occuring?

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

    Default

    Just talked to client, there are no macros to hide sheets.

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
  •