Microsoft® Office Excel® 2003 Step by Step

Chapter 12 Automating Repetitive Tasks with Macros

Introducing Macros To open and view a macro

1. Open a workbook with a macro attached.

2. Click Enable Macros to allow macros to run.

3. On the Tools menu, point to Macro and then click Macros.

4. In the Macro Name pane, click the name of the macro to view.

5. Click Edit.

6. Click Close to close the macro.

Introducing Macros To step through a macro

1. On the Tools menu, point to Macro and then click Macros.

2. In the Macro Name list, click the name of the macro to step through.

3. Click Step Into.

4. Right-click the taskbar, and then, from the shortcut menu that appears, click Tile Windows Vertically.

5. Press to execute each macro step.