Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    Unanswered: How to make a macro a personal macro

    How do you make a macro a personal macro? Simple question, I know, but never have done it before

  2. #2
    Join Date
    Feb 2004
    Create your macro workbook save it with the name "PERSONAL.xls" in the XLStart Folder.

    C:\Documents and Settings\USER NAME\Application Data\Microsoft\Excel\XLSTART\PERSONAL.xls

    If you record a macro and select record to "Personal Macro File" it will create the file in your XLStart folder as the default.

    I don't use the PERSONAL.xls workbook. You do not have to have it named personal.xls to run macros.


Posting Permissions

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