Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM AN ICON
Copying Icons from Other Ofﬁ ce Applications
Rather than create your own icon using the Button editor, as shown in Figure
120, see if another application already has the icon. For example, the idea
for Filter to Selection came from Access. It is likely that Access already has
an icon called Filter to Selection. If so, you can copy the icon from one Ofﬁ ce
application to Excel. Follow these steps:
Keep Excel open and open Access (or Word or PowerPoint).
In Access (or Word or PowerPoint), ﬁ nd the Filter to Selection icon, which
appears only when you are viewing a table. Finding the icon might require
a few steps. If you don’t have an Access table, use File, Import to import
an Excel worksheet into a table. Then double-click the table to view it in
Data Sheet mode. The desired icon now appears on the Table Datasheet
Right-click the toolbar and choose Customize.
While the Customize dialog is displayed, right-click the desired icon and
choose Copy Button Image.
Switch back to Excel.
Choose Tools, Customize.
Right-click the desired icon and choose Paste Button Image. A new menu
item is added, with a shortcut key and a professional-looking icon. As shown
in Figure 121, this item looks like it is part of the core Excel product.
Figure 121. A custom but on with
an image copied from Access runs
the macro in the Personal Macro
Summary: Excel 2003 is better than Excel 2007 for adding custom menu