O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required