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.
For Excel 2003 and Earlier
In Excel 2003 or an earlier version of Excel, open any workbook. Choose Tools, Macro, Record New Macro.