Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Thanked 0 Times in 0 Posts

    Personal.xls File in XLStart Folder (Excel 97)

    I have created macros (in the personal.xls file of the XLStart folder) which are automatically loaded every time I start Excel, without having to asking me to enable/disable them.
    I have since placed this file in the XLstart folders of all my collegues. However, when I need to change any of the macros, I have to re-copy the personal.xls file in all my collegues' XLstart folders.

    Is there a options/preferences setting in excel that I can change to allow all users to point the personal.xls file one common location?
    (i.e. network drive location accessed by all my collegues)


  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Personal.xls File in XLStart Folder (Excel 97)

    Select Options from the Tools menu and click on the General tab. Put the path to the folder in the "Alternate startup file location" text box.
    Legare Coleman

Posting Permissions

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