Running the Macro
After you create a macro, you can use it to repeat its commands. Excel offers many ways to run a macro. Here are the two most common methods for running a macro:
Select Tools, Macro, Macros, Run.
Use the macro shortcut key (if you defined one).
The quickest way to run the macro is to use the macro shortcut key. If the macro doesn't have a shortcut key assigned to it, you must use Tools, Macro, Macros, Run.
In the following To Do exercise, you run the macro you just created by using the macro name, Font_change.
To Do: Run the Macro
1. | First select cell A1 in the Summary sheet. This data in this cell needs a font change. |
2. | Choose Tools, Macro, Macros. The Macro dialog box appears, as shown in Figure 20.4.
Figure 20.4. The Macro ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
