Executing the procedure from the Macro dialog box

Most of the time, you execute Sub procedures from Excel, not from the VBE. The steps below describe how to execute a macro using Excel's Macro dialog box.

1. Activate Excel.

Alt+F11 is the express route.

2. Choose ToolsOMacroOMacros (or press Alt+F8). Excel displays the dialog box shown in Figure 5-3.

3. Select the macro.

4. Click Run (or double-click the macro's name in the list box).

Figure 5-3:

The Macro dialog box lists all available Sub procedures.

Figure 5-3:

The Macro dialog box lists all available Sub procedures.

0 0

Post a comment