Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opens in Personal.xls workbook (Excel 2000)

    A user created a macro in the Personal.xls workbook that was unhidden and then saved and closed it.
    Now when Excel is opened, it opens with the workbook Personal.xls and not Book1 as normal.
    How do we close the Personal.xls workbook so that Book1 etc opens again?
    Must we hide it or something?

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Opens in Personal.xls workbook (Excel 2000)

    With Personal.xls as the active workbook, select Window | Hide. Quit Excel and reply Yes to the prompt to save Personal.xls. Next time you start Excel, Personal.xls will be loaded, but hidden.

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opens in Personal.xls workbook (Excel 2000)

    Thanks Hans
    Save my skin!

Posting Permissions

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