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.
- 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.
