Macro available to all workbooks

[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?

 

[Ken Wright]

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.