Microsoft Office Tutorials and References
In Depth Information
MAKE A PERSONAL MACRO WORKBOOK
MAKE A PERSONAL
Challenge: Macros stored in the Personal Macro Workbook are always at
your disposal. You can run the macros on any workbook that you open on the
computer. Also, you do not have to jump through security hoops to run macros
stored in the Personal Macro Workbook.
If you have never used the Personal Macro Workbook, it does not exist on your
computer. You need to create one.
For Excel 2003 and Earlier
In Excel 2003 or an earlier version of Excel, open any workbook. Choose Tools,
Macro, Record New Macro.
In the Macro Name ﬁ eld, type HelloWorld (without a space). Open the Store
Macro In dropdown and choose Personal Macro Workbook. Leave the Shortcut
Key ﬁ eld blank. There is no need to change the Description ﬁ eld for this tiny
macro. The dialog should appear as in Figure 97. Click OK.
Figure 97. To force Excel to create a Personal Macro Workbook, record
a tiny macro to go there.