Now that the macro has been created, how do you run it? First we need to open the list of macros; to do this we'll click the Tools menu, choose Macro, and click Macros. (You can also use the Alt+F8 shortcut.)

 

A dialog will appear listing all of your macros:

 

 

When you click on a macro its name will appear in the Micro name box with its description below. You can also use the drop-down menu to choose where to look for macros.

 

Here’s a description of each of the buttons on the right hand side:

-          Run: Runs the selected macro.

-          Step Into: Lets you run the macro line by line in Visual Basic Editor.

-          Edit: Opens the macro in Microsoft Visual Basic Editor so you can edit it.

-          Create: Creates a new macro in the Visual Basic Editor, overwriting the selected one.

-          Delete: Deletes the selected macro.

-          Organizer: Opens the macro organizer.

-          Cancel: Closes this dialog without making any changes.

 

So, to run a macro, just select it in the pane marked with a 2 and click Run. The macro will execute and this dialog will close.