More Tricks with Graphic Objects

But wait, there’s more! We’ll now 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 to display what’s happening in other areas of the workbook or in other workbooks.

Assigning Macros to Objects

You can attach a macro to any object, allowing you to activate the macro by simply 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 ...

Get Microsoft® Office Excel® 2007 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.