Page 225 - Excel Progamming Weekend Crash Course

k540629 ch16.qxd 9/2/03 9:34 AM Page 200

200 Saturday Afternoon

You can assign a macro to any toolbar button, not just custom buttons. This
is best avoided, however, because users tend to associate the graphic on
Note toolbar buttons with the default command that is assigned.
After you have assigned a program, or macro, to a toolbar button, clicking the button
runs the program just as if you selected it from the macros dialog box.
To change the name of a custom button:
1. Right-click the button on the toolbar to display the pop-up menu (see Figure 16-5).
You must do this while the Customize dialog box is displayed.

Figure 16-5 Changing a custom button’s name

2. The third item on the menu is Name:. Click in the box next to this menu item and
then edit/enter the new button name. Optionally, place an ampersand (&) charac-
ter in front of the character that will serve as the button’s access key.
3. Click outside the pop-up menu to close it.

The access key for a toolbar button is a character — usually a letter — that
can be pressed along with the Alt key to select the button (as an alternative
Note to clicking the button). A button’s access key is displayed underlined on the
toolbar. A button’s access key works only if the button’s title is displayed; if
only the button’s image is displayed, the access key is inactive.

Never assign an access key that is used by an Excel menu command, such as
Alt+F for the File menu. Doing so is likely to result in confusion for the user.
Never