WorkbookItem Members

Workbook Item Object.

Functions

Name Description
Activate Sets the focus to the workbook item.
Delete Deletes the item from the workbook.
ExpandAll Expand all child items.
Extract Extracts a copy of the item from the workbook.

Return value: Object.

PrintOut Prints out the workbook item.
Select Sets the focus to the workbook item.

Properties

Name Description
Active Returns whether the workbook item is active.

Return value: Boolean.

This property is read only.

Application Returns the application associated with the workbook item.

Return value: .

This property is read only.

Child Returns the first child workbook item. Return value: .

This property is read only.

Columns Returns or sets the number of columns of a folder multi-item display.

Return or assignment value: Integer.

Expanded Expanded state.

Return or assignment value: Boolean.

HasWorkbookHeaderFooter Returns or sets whether the workbook item will display a header/footer when printed. Return or assignment value: Boolean.
Height Returns or sets the height of folder multi-item display in twips.

Return or assignment value: Integer.

ID Returns the ID of the workbook item. Return value: LONGLONG.

This property is read only.

Image Sets the image of the workbook item. Return or assignment value: .
ItemPath Returns a pathspec for the item that can be used in a Workbook's Item() method. Return value: String.

This property is read only.

Lock Sets/clears a lock so the workbook item is not/is garbage collected.

Assignment value: Boolean.

MultiItemDisplay Returns or sets whether to use multi-item display.

Return or assignment value: Boolean.

Name Returns or sets the workbook item name. Return or assignment value: String.
Next Returns the next sibling workbook item. Return value: .

This property is read only.

Object Returns the dispatch interface of the workbook item.

Return value: Object.

This property is read only.

Parent Returns the parent workbook item. Return value: .

This property is read only.

Path Returns the path of the workbook associated with the workbook item. Return value: String.

This property is read only.

PersistentID Persistent ID.

Return value: String.

This property is read only.

Previous Returns the previous sibling workbook item.

Return value: .

This property is read only.

PrintOrientation Print orientation.

Return or assignment value: .

Selected Returns whether the workbook item is selected.

Return value: Boolean.

This property is read only.

SupportsWorkbookHeaderFooter Returns whether the workbook item can contain a header or footer when printed. Return value: Boolean.

This property is read only.

Tag String data.

Return or assignment value: String.

Type Returns the type of the workbook item. Return value: .

This property is read only.

Width Returns or sets the width of folder multi-item display in twips.

Return or assignment value: Integer.

Workbook Returns the workbook associated with the workbook item.

Return value: Workbook.

This property is read only.