Sheet Properties: Objects

The Sheet Properties: Objects page helps you to keep track of all sheet objects residing on the current sheet. This makes it much easier to get hold of objects that are hidden or have show conditions.

Sort the table on any column, by clicking its column header. The columns contain the following information:

Object ID Lists the unique Object ID of every existing sheet object. Linked objects have the same object ID.
Type Clarifies the object type.
Caption Gives the text, if any, that is displayed in the caption of the object.
ShowMode Indicates whether the object is normal, minimized, maximized, hidden or has a show condition.
State

Displays which state the object is in.

See: Alternate States

CalcTime The time in milliseconds needed for the last recalculation of the object's contents. This information is only relevant for objects that are actually calculated (charts, table boxes and any objects containing formulas).
Layer The layers are set on the Sheet Object Properties: Layout page where Bottom, Normal and Top correspond to the numbers -1, 0 and 1. Choose Custom to enter a value of your choice. Valid layer numbers are -128 to 127.
Memory The amount of transient memory needed for the last recalculation of the object's contents. This information is only relevant for objects that are actually calculated (charts, table boxes and any objects containing formulas).
Left, Top, Right,
Bottom
The current position of the indicated edge of the sheet object relative to the edge of the document window, expressed in pixels.
Width, Height The size dimensions of the object, expressed in pixels.
Left (Min), Top (Min), Right (Min),
Bottom (Min)
The current position of the object when iconized (=minimized).
Width (Min), Height (Min) The dimensions of the object's icon.

After clicking an object in the list, you can use the buttons to either Delete it or open its Properties dialog directly from this menu. Multiple objects can be selected with Ctrl+Click.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?