Excel 2007 / 2010 Macro Tutorial

Running a Macro in Excel

Note: For help on these steps, refer to the image above.

To run a macro you have recorded:

1. Click on the Sheet2 tab at the bottom of the spreadsheet.
   
   
2. Click on cell A1 in the worksheet.
   
   
3. Type the title: Cookie Shop Expenses for July 2008.
   
   
4. Press the Enter key on the keyboard.
   
   
5. Click on the Developer tab of the ribbon.
   
   
6. Click the Macros button on the ribbon to bring up the View Macro dialog box.
   
   
7. Click on the format_titles macro in the Macro name window.
   
   
8. Click the Run button.
   
   
9. The steps of the macro should run automatically and apply the same formatting steps applied to the title on sheet 1.
   
   
10. At this point, the title on worksheet 2 should resemble the title on worksheet 1.

• Excel Macro Recorder Tutorial
• Adding the Developer Tab
• Adding a Worksheet Title / The Excel Macro Recorder
• The Macro Recorder Options
• Adding the Macro Steps
• Running the Macro
• Macro Errors / Editing a Macro