Executing the procedure from the Macro dialog box
Most of the time, you execute Sub procedures from Excel, not from the VBE. The following steps describe how to execute a macro by using Excel’s Macro dialog box.
1. Activate Excel.
Alt+F11 is the express route.
2. Choose Developer➪Code➪Macros (or press Alt+F8). Excel displays the dialog box shown in Figure.
3. Select the macro.
4. Click Run (or double-click the macro’s name in the list box).
No comments:
Post a Comment