Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM AN ICON
For Excel 2003
Excel 2003 and prior versions offer more options for adding icons to your
toolbars. The icon can be added to any toolbar or even to a new toolbar. (See
“Run a Macro from a Button” on page 102). You can use a selection of default
icons, draw your own icon, or even copy an icon from another application.
Right-click any toolbar and choose Customize or select Tools, Customize.
Select the Commands tab in the Customize dialog.
Scroll down in the left list box to almost the end. Choose Macros, the third
item from the end of the left list box. The right list box offers two icons: a
smiley face and an icon with nothing. Even if you hate the smiley face, use
it for now.
Drag the smiley face icon from the right list box and drop it in the desired
location on any toolbar or menu. Figure 117 shows the new icon being
added to the Filter ﬂ y-out on the Data menu.
Figure 117. You can drag the smiley face to any existing toolbar or