Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM AN ICON
Keep the Customize dialog box open. Find your new icon on the menu or
toolbar. Right-click the icon or click it and choose Modify Selection in the
Customize dialog. From the menu that appears, adjust the settings in step
6 and optionally follow any of steps 7 through 11.
From the bottom of the menu, choose Assign Macro. Choose the appropriate
macro and click OK.
Choose Change Button Image and select one of the 48 default images
instead of the smiley face (Figure 118).
Figure 118. You are not stuck with the smiley face.
Type a new name for the button. This name will appear in menus and will
appear as the ToolTip when the icon is in a toolbar.
Tip: If your icon is in a menu, add a shortcut key by preceding one letter in the
name with an ampersand. For the menu shown in Figure 119, for example,
the name is Filter &to Selection. This causes the t in to to be underlined,
and it makes the command sequence to access the new button Alt+D+F+T
(D opens to Data menu, Filter opens the Filter menu, and T selects Filter to