Assigning Macros to Graphics

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:

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

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