Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM AN ICON
By default, every macro starts out with an identical ﬂ owchart icon. To change
the icon, click the Modify button, which appears below the right list box.
There are 181 icons available (Figure 115). Choose one that will remind
you of the action in the macro. Change the display name to something
friendlier. This name will be displayed when you hover over the icon in the
Quick Access toolbar.
Figure 115. You customize the icon from this
selection of icons.
Click OK to close the Excel Options dialog. The new icon appears in the
Quick Access toolbar, as shown in Figure 116.
Figure 116. h
e new icon appears in the Quick Access toolbar.
Tip: There is one bit of new functionality in Excel 2007: You can add to the
Quick Access toolbar an icon that appears only when a particular workbook
is open. To add an icon for one workbook, use the top-right dropdown in the
Customize dialog. Change the setting from For All Documents (Default) to For