Make A Personal Macro Workbook

May 5, 2021 - by Bill Jelen

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.

Solution:

For Excel 2003 and Earlier

In Excel 2003 or an earlier version of Excel, open any workbook. Choose Tools, Macro, Record New Macro.