How to create global macros in Excel 2010

I found this site's instructions useful for saving macros.  Basically whenever Excel 2010 starts, it loads everything in the folder C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART
So you want to store the macros in there somehow.  To do that, do the following:

1) Open Excel 2010
2) Click the View tab to open the View ribbon
3) Click Macros
4) Click Record Macro
5) Type in the name of the macro under Macro name
6) Type in a brief description of the macro under Description
7) Click OK
8) Click Macros
9) Click Stop recording
10) Press ALT+F11 to open the Excel VBA development window
11) In the VBA development window, click the + next to Modules
12) Module1 should be displayed.  If not, start over
13)  Double click Module1
14) Type in your VBA macro code
15) Click on the floppy diskette icon to save the VBA macro workbook

Now whenever you open Excel, the macros inside PERSONAL.XLSB file which is hidden within the Users folder mentioned at the beginning of this blog entry will automatically load.

http://blog.johnmuellerbooks.com/2011/09/02/creating-global-macros-in-excel-2007-and-2010.aspx