Assigning Macros to Graphics

Summary: Depending on your version of Excel, macros are usually added to toolbars and menus. You can also add them to graphics, so that the macro is executed when someone clicks on the graphic. This tip explains how to establish that relationship between a graphic and a macro. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

You already know that Excel allows you to add graphics to your worksheets, such as pictures. You may not know, however, that you can assign macros to these graphics. With a macro associated with a graphic, the macro is executed whenever someone clicks on the graphic.

To assign a macro to a graphic, follow these steps:

Right-click on the graphic. Excel displays a Context menu.
Select the Assign Macro option from the Context menu. Excel displays the Assign Macro dialog box. (Click here to see a related figure.)
Select the macro you want associated with the graphic.
Click on OK.

Save your workbook and test out your assignment by clicking on the graphic. The macro should run, as desired.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2971) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Assigning Macros to Graphics