How to Run Excel 2003 Macros in Excel 2007

Excel 2003 macros are compatible with Excel 2007.

Macros are pieces of code that you can use to customize your Excel spreadsheet. Macros can be created through the "record macro" function in Excel, or create your own using Visual Basic for Applications (VBA) code in the Visual Basic Editor (VBE). However you created the macros in Excel 2003, you'll need to access the macro's code (located in the VBE) in order to copy the code over to Excel 2007.

Instructions

Copying the Excel 2003 Macro

1. Press "Alt" and "F11" from the Excel 2003 workbook that the macro is attached to.

2. Click on the macro name in the left-hand list box. This will open a window with the macro code.

3. Copy the entire code (select all of the text, then click "Ctrl" and "C" together).

Copy to Excel 2007

1. Open the VBA editor by clicking on "Alt" and "F11" from any worksheet.

2. Open a new module by clicking on "Insert->Module."

3. Paste the code into the module by pressing on "Ctrl" and "P" together. The macro is now ready to run in your workbook.

Tips & Warnings

• If the macro you want to copy is located on another computer, send yourself an email with the code inside the email. At the target computer, copy the code from the email before you paste it.

References

• Microsoft: About Excel macros