Macro available to all workbooks

  • Thread starter Thread starter Bob Lyons
  • Start date Start date
B

Bob Lyons

I just switched from Excel 97 to Excel 2002.

In Excel 97 you had a personal.xls file that would store
macros available to all workbooks.


How do you do this in Excel 2002?
 
Exactly the same, but until you record a macro and tell Excel to store it in your 'Personal Macro
Workbook' it will not exist. Record a macro, tell it to store it in your Personal Macro Workbook,
type a 1 somewhere, stop the macro, and then you can use ALT+F11 to go find it in the VBE. Then
just delete the macro you recorded and put in your other macros.
 
Back
Top