How to Convert Excel 2003 Macros to Excel 2007

Change the Macro Settings in Excel 2007
1. Click on the 'Office' Button.
2. Select 'Excel Options.'
3. Choose 'Trust Center->Trust Center Settings->Macro Settings.'
4. Click on 'Trusted Locations->Add New Trusted Locations.'
5. Add your workbook's location and then select 'OK.'
6. Open the workbook again in Excel 2007 and check for working macros. If they still don't work, you'll need to copy and paste the macro text over (see Section 2).
Copy and Paste
7. Open the workbook in Excel 2003.
8. Locate the code for your macro. An easy way to locate code for a particular macro is to click on the 'Tools' menu, and then 'Macro->Macros.' Find the macro name and then click 'Edit.'
9. Highlight the entire section of code and then press 'Ctrl' and 'C.'
10. Paste the text into a text file (using a program like Notepad or Wordpad).
11. Open the VBE in Excel 2007 and paste the code into a new code window.