Page 31 - Excel for Scientists and Engineers: Numerical Methods

8 EXCEL: NUMERICAL METHODS

Running a Sub Procedure

In the preceding example, the macro was run by using a shortcut key. There
are a number of other ways to run a macro. One way is to use the Macro dialog
box. Again, enter a number in a cell, select the cell, then choose Macro from the
Tools menu and Macros.. from the submenu. The Macro dialog box will be
displayed (Figure 1-9). This dialog box lists all macros in open workbooks
(right now we only have one macro available). To run the macro, select it from
the list, then press the Run button.

Assigning a Shortcut Key to a Sub Procedure
If you didn't assign a shortcut key to the macro when you recorded it, but
would like to do so "affer the fact," choose Macro from the Tools menu and
Macros ... from the submenu. Highlight the name of the macro in the Macro
Name list box, and press the Options ... button. You can now enter a letter for
the shortcut key: CONTROL+<key> or SHIFT+CONTROL+<key> in Excel for

Figure 1-9. The Macro dialog box.

Windows, OPTION+COMMAND+<key> or SHIFT+OPTION+COMMAND+<key>
in Excel for the Macintosh.