Page 37 - Excel for Scientists and Engineers: Numerical Methods

14 EXCEL: NUMERICAL METHODS

When you display the Properties window, you will see the single property of
a module sheet, namely its name, displayed in the window. Simply double-click
on the name (here, Modulel), edit the name, and press Enter. No spaces are
allowed in the name.
How Do I Add a Shortcut Key? If you decide to add a shortcut key to a
command macro "after the fact," choose Tools+Macro+Macros.. . . In the
Macro Name list box, click on the name of the macro to which you want to add a
shortcut key, then press the Options button. In the Shortcut Key box, enter a
letter, either lower- or uppercase. To run the macro, use CTRL+<letter> for a
lowercase shortcut key, or CTRL+SHIFT+<letter> for uppercase.
Warning: The shortcut key will override a built-in shortcut key that uses the
same letter. For example, if you use CTRL+s for the ScientificFormat macro,
you won't be able to use CTRL+s for "Save." This will be in effect as long as the
workbook that contains the macro is open.

How Do I Save a Macro? A macro is part of a workbook, just like a
worksheet or a chart. To save the macro, you simply Save the workbook.

Are There Some Shortcut Keys for VBA? Yes, there are several. Here's
a useful one: you can toggle between the Excel spreadsheet and the VBA Editor
by pressing ALT+Fl 1 . A list of shortcut keys for VBA programming is found in
Appendix 2.