More Tricks with Graphic Objects

But wait, there’s more! We’ll describe a few features that are hard to classify with the other graphics features. You can essentially turn any graphic object into a button by assigning a macro to it. In addition, you can take pictures of your worksheets and use those pictures in Excel workbooks (or even in other programs); they can appear as static bitmaps or dynamic windows that display what is happening in other areas of the workbook or in other workbooks.

Assigning Macros to Objects

You can attach a macro to any object, which lets you activate the macro by clicking the object. To attach a macro to an object, do the following:

  1. Right-click the object, and click the Assign Macro command.

  2. When the Assign Macro dialog ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.