Results 1 to 3 of 3
  1. #1
    LeTaylor
    Guest

    E97: Personal.xls

    Hi..

    I used to have a macro in Personal.xls that I always used. Well I have no need for Personal.xls to open any mored, so I deleted the Macro thinking that would help..

    It didn't.. Now when I open up excel the default file that opens in Personal.xls. How do I change it so that only a new sheet opens and Personal.xls doesn't open at all..

    Thanks!

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: E97: Personal.xls

    You can discontinue Personal.xls from loading by removing it from your xlstart directory. As it is useful for holding 'global' macros, maybe you should consider retaining it. It can be hidden so that it is inconspicuous.

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E97: Personal.xls

    You can hide it, so that although it opens, you don't have to know anything about it.
    When in Personal.xls, choose Window|Hide and then exit Excel. Next time you go into XL, you won't see personal.xls. If you want to open it again, then Window|Unhide will list it in the dialog box.

    Ruth

Posting Permissions

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