1. Click 'View' and then click 'Macros.'
2. Click 'Record' macro to open the Record Macro window.
3. Click the arrow underneath 'Store macro in:' to open the drop down menu.
4. Click 'Personal macro workbook' to store the macro in the Personal.xls workbook. The macro will be available for use in any workbook.