Excel 2003 Macro Tutorial

The Macro Recorder Options

Excel Macro Tutorial

© Ted French

The Macro Recorder dialogue box

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

There are 4 options to complete in this dialog box:

1. Name – give your macro a descriptive name.
   
   
2. Shortcut key - (optional) fill in a letter in the available space. This will allow you to run the macro by holding down the CTRL key and pressing the chosen letter on the keyboard.
   
   
3. Store macro in –
   Options:
   • the current workbook
     • The macro is available only in this file.
   • a new workbook
     • This option opens a new Excel file. The macro is available only in this new file.
   • a personal macro workbook.
     • This option creates a hidden file – Personal.xls – which stores your macros and makes them available to you in all Excel files.
   
   
   
4. Description - (optional) enter a description of the macro.

• Excel Macro Recorder Tutorial
• Starting the Excel Macro Recorder
• The Macro Recorder Options
• Excel Macro Recorder
• Running a Macro in Excel
• Editing a Macro