Microsoft Office Tutorials and References
In Depth Information
Activating a Macro with a Keyboard Shortcut
Activating a Macro with a Keyboard Shortcut
Until now we’ve been triggering our macros with a series of mouse clicks, an ever-so-
slightly tedious routine that can be streamlined by designating a keyboard shortcut to do
the job instead. You can assign a shortcut key to a macro either during the macro
design process or retroactively. Let’s look at these options.
First, recall that when you compose a macro, you’re brought to the Record Macro dialog
box, shown in Figure 11–18. Notice the Shortcut key option, which enables you to
designate a key that teams with the Ctrl key. Pressing that combination will start the
macro.
Figure 11–18. The Shortcut key option: A speedy way to initiate a macro
You can assign a shortcut key to a macro that you’ve already created as well. Here’s
how:
1.
Click View Macros (you needn’t click the arrow), and click the name of
the macro to which you want to assign the shortcut key. You’ll see the
dialog shown in Figure 11–19.
 
Search JabSto ::




Custom Search