How to save and share excel macros

1. Create all macros as part of a work book
2. Save those to the personal workbook (Personal.xlsb) - On "Create Macro" dialog, chose "Personal Macro Workbook". Macro will then be saved to the location

C:\Users\\AppData\Roaming\Microsoft\Excel\XLSTART

It is opened as a hidden workbook every time you start Excel. Excel saves the personal workbook as Personal.xlsb, in the following folder on Windows 7 and Windows Vista computers:


http://office.microsoft.com/en-us/excel-help/create-and-save-all-your-macros-in-a-single-workbook-HA102174076.aspx