How to Import a Macro to Excel 2007

1. Open the Microsoft Excel 2007 file that you want to import the macro code into and then click on the 'Developer' tab.
2. Click on the 'Macro Security' option from the 'Code' group. Click on the 'Macro Settings' option from the 'Macro Settings' category.
3. Click on the 'Enable all macros' option and then click on the 'OK' button. Minimize your workbook.
4. Open the Excel file that contains the macro that you want to copy. Click on the 'Developer' tab and then click on the 'Visual Basic' option from the 'Code' group.
5. Click on the 'View' menu option and then click on the 'Project Explorer' option. Click on the macros module you want to import and drag into the other workbook that you want it copied to. The macro will then be fully added to your workbook.