How to Attach Macros to All in Excel

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.