Microsoft Office Tutorials and References
In Depth Information
More tricks with graphic objects
Controlling the display of objects
You might want to suppress the display of objects in a workbook for security reasons
or to simply speed up scrolling on an older computer. To do so, click the File tab, click
Options, and select the Advanced category. In the Display Options For This
Workbook area, the For Objects, Show All option is ordinarily selected. Selecting the
Nothing (Hide Objects) option prevents both their display and printing. Note that hiding
objects in this way removes all traces of them. If, before hiding all the objects, you first
display the Selection pane, you can see a list of the hidden objects on the active sheet.
If you want to hide individual objects rather than all of them, use the Selection pane.
For more information about the Selection pane, see the discussion surrounding
Fig ure 10-48 earlier in this chapter.
Although you cannot directly modify objects when they are hidden, some actions still
change them. If you select anything other than Don’t Move Or Size With Cells in the
Format Shape task pane, hidden objects still respond to adjustments made to the
column width or row height of underlying cells.
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:
Right-click the object, and click the Assign Macro command.
1.
2. When the Assign Macro dialog box appears (shown in Figure 10-51), assign a macro
to the object by clicking New to create a new macro using the Visual Basic Editor, by
clicking Record to create a new macro by example, or by selecting an existing macro
from the list.
For more information about macros, see Chapter 28, “Recording macros.”
Search JabSto ::




Custom Search