Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: personal workbook

    i need to setup a personal workbook to save macros and stuff in. i dont remember how to do this- actually i don't remember doing this at all. i thought it is installed when you install excel. Does anyone know how to add this personal workbook?

  2. #2
    Join Date
    Feb 2003
    Location
    Wichita,KS
    Posts
    44
    Simply add your macros to an empty workbook. From the menu choose Window, Hide and close the file.
    Move the file to your Excel start folder. In W2k it is:
    C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART
    Now every time Excel starts, it will load this workbook as hidden and your macros will be available. I name mine Personal.xls so that I can easily find it.

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    or more simple

    record a macro and choose the location to be personal Macro Workbook

    and this will automatically create your personal.xls file for you

  4. #4
    Join Date
    Feb 2003
    Location
    Wichita,KS
    Posts
    44
    Simple is better.

Posting Permissions

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