How to Record a Macro in Excel 2003

Macros are mini programs that help you quickly do tasks in Excel. If you can perform a series of actions in Excel, you can create a macro for that series of tasks and use it as a shortcut. Learn how to record a macro in Excel 2003.

Difficulty: Moderate

Instructions

Things You'll Need:

• Computer with Excel 2003

1. Open Excel. Either open the program itself or open an existing file.

2. Set your security level. Go to "Tools > Options." Go to the Security tab and click on "Macro Security." Go to the Security Level tab and change the level to medium or low.

3. Go to "Tools > Macro." Choose "Record New Macro" from the options.

4. Type a name into the macro name box.

5. Type the location of the macro into the box labeled "Store Macros In." Click “OK."

6. You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.

7. When you are finished, click "Stop Recording" on the toolbar. You may make as many macros as you need.

Tips & Warnings

• A Shortcut Key identifies how you'd like to trigger your macro to run. If you enter the letter "K" into the Shortcut Key box when creating your macro, then when you are ready for the macro to run, hit "Ctrl" and "K" and the macro will start.
• If you make a mistake while recording the macro, just fix it as you normally would.
• Remember to save your work after recording a macro.