Word Document Properties

SayGoodbye
in the Macro Name field
,
and the
Macro dialog box enables the Create button and disables everything else, as
shown in Figure 2-6. You can use this dialog box to create any new programs
that you need.
Figure 2-6:
Typing a
non-existent
macro name
in the Macro
Name field
enables the
Create
button.
Figure 2-5:
Use the
Macro
dialog box to
access the
programs
that you
create.
41
Chapter 2: Your First VBA Program
06_046500 ch02.qxp 12/5/06 5:33 PM Page 41

---

Using the quick-launch methods
It isn’t always convenient or efficient to open the Macro dialog box to run the
programs that you design. If you use the same program several times a day,
opening the Macro dialog box can become a time-wasting event. What you
need is a 
quick-launch method 
— a way to start the program that doesn’t
require you to open the Macro dialog box.
Defining a shortcut key
The Macro dialog box, shown in Figure 2-5, has one other use that helps
you create quick-launch programs. Open the Macro dialog box by using the
Tools
➪
Macro
➪
Macros command or by clicking Macros on the Developer
tab on the Ribbon. Highlight the program that you want to launch quickly
(
SayHello
, for this example). Click the Options button. Excel opens the
Macro Options dialog box. Type 
h
in the Shortcut Key field and 
This is a
simple program.
in the Description field. Your dialog box should look like the
one shown in Figure 2-7.
Click OK to close the Macro Options dialog box, and then click Cancel to close
the Macro dialog box. When you press Ctrl+H, the program that you created
earlier should run and display the same two dialog box sequences as before.
Defining a toolbar button
Using shortcut keys is fine when you don’t have a lot of them to remember
and you don’t mind performing finger gymnastics. However, you don’t have
to limit yourself to keyboard shortcuts. If you’re using an older version of
Office or one of the newer versions with the standard toolbar interface, you
can place a button on a toolbar that starts your program. When working with