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

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Assigning Macros to Graphics