Microsoft Office Tutorials and References
In Depth Information
Executing Macros
Executing Macros
Excel provides a number of ways to execute macros. These are described in the
following sections.
Using the Macro dialog box
The Tools
Macros command (or Alt+F8) displays the Macro dialog box,
which lists all available macros. To execute a macro, select it in the list and click Run.
Using a shortcut key
When you record a macro, the Record Macro dialog box offers the option to
specify a shortcut key to be associated with that macro. You can, however, associate a
shortcut key with any existing macro. To specify a shortcut key for a macro (or to
change the existing shortcut key):
1. Select Tools
Macros (or Alt+F8) to display the Macro dialog box.
2. Select the macro from the list.
3. Click Options to display the Macro Options dialog box (see Figure 15-6).
4. Specify the shortcut key for the macro (an uppercase or lowercase letter).
Figure 15-6: Using the Macro Options dialog
box to specify a shortcut key for a macro
Assigning a macro to a toolbar button
If the macro is a general-purpose macro that you plan to use in more than one
workbook, you may want to assign it to a button on a toolbar. First, ensure that the
macro is stored in your Personal Macro Workbook so that it will always be
available. Then:
Search JabSto ::

Custom Search