Page 32 - Excel Timesaving Techniques for Dummies

03_574272 ch02.qxd 10/1/04 10:23 PM Page 17
If you want to assign a hot key to the name Adding Macros and Links to Toolbars and Menus 17
When you select the Macros category, the
you give your new custom menu, type an Commands list box gives you a choice between
ampersand (&) immediately in front of the a Custom Menu Item and a Custom Button.
letter in the menu name. (Just make sure that
it isn’t already assigned to one of the other
items on the same menu.)
To add an item to your new menu, drag the com-
mand from the Customize dialog box to the tab
under the menu. (Don’t release the mouse button
until the bold, I-beam-type indicator appears on the
tab and the box with the plus sign (+) appears next
to the mouse pointer.) Removing and repositioning
items on your custom menu is no different from mak-
ing these types of modifications to a standard pull-
down menu.

Adding Macros and Links
to Toolbars and Menus

Built-in commands are not the only things you can
add to the toolbars and pull-down menus you cus- • Figure 2-4: The Macros category contains two choices:
tomize or create from scratch. You can also add Custom Menu Item and Custom Button.
macros you’ve recorded and hyperlinks to particular
documents, folders, and even favorite Web sites. To 4. Drag the Custom Button (with the Happy Face
do this, you attach the macro or link to a custom icon) and drop it into position on the toolbar
button that you add to a toolbar or to a custom from which you want to be able to run the
menu item that you add to a pull-down menu. macro or select the hyperlink.
5. Right-click the Custom Button you just added
To attach a macro or hyperlink to a custom button
to the toolbar and then click either the Assign
that you add to a toolbar, follow these steps: Hyperlink➪Open item (to attach a hyperlink to
it) or the Assign Macro item (to attach a macro
1. Choose View➪Toolbars➪Customize to open the to it) on the shortcut menu, shown in Figure 2-5.
Customize dialog box.
If you choose Assign Hyperlink➪Open, Excel
2. If the toolbar to which you want to add the opens the standard Assign Hyperlink dialog box
custom button is not already open, select the where you can select an existing file or Web page
Toolbars tab and then select the toolbar’s or e-mail address to link to. If you choose Assign
check box to display it in the Excel screen. Macro, the program opens the Assign Macro dia-
3. Select the Commands tab and then select log box where you can select the macro to run
Macros near the bottom of the Categories list when the button is clicked.
box, as shown in Figure 2-4.