How to create a macro *template* to store macros to be available in all workbooks:
You can create a worksheet to hold all the macros and have that worksheet always run when you open Excel. To do this, run Windows Explorer and go to C:\Program Files\Microsoft Office\Office\Xlstart (assuming you used the default location when you installed Office).
Right-click the right pane of Xlstart and choose New, Text Document. Name your new document personal.xls and press Enter. When asked if you want to change the extension, click Yes.
Now double-click your new file to open it in Excel. Next, choose Window, Hide and then choose File, Exit. When asked if you want to save the Personal macro workbook, click Yes. The next time you run Excel, personal.xls will run but remain hidden.
To store your macros in personal.xls, choose Window, Unhide to unhide personal.xls. After you finish storing your macros, choose Window, Hide to hide personal.xls again.
Bookmarks