Overview
Sometimes we find we are copying modules between workbooks just to use a few macros in them. It may be more efficient to store your custom macros in one place. Note, however, that this may not be the best solution for collaboration. If another team member will be using the same macros upon opening the workbook, then it is not a good idea to store them in a personal location.
Process
Create the Personal workbook.
Open Developer tab.
Click “Record Macro”.
Don’t worry about naming the macro; it will be temporary.
In “Store macro in” box, select “Personal Macro Workbook”.
Click “OK”.
The PERSONAL.xlsb file will now be created in the XLSTART folder.
To use common macros, copy them to modules within the PERSONAL.xlsb file. It will be launched each time Excel opens.
Resources
https://www.techrepublic.com/blog/microsoft-office/quick-tip-find-excels-xlstart-folder-fast/