OLEObject Properties

Name Returns

Description

AutoLoad

Boolean

Set/Get whether the OLE object is automatically loaded when the workbook is opened. Not valid for ActiveX controls. Usually set to False

AutoUpdate

Boolean

Set/Get whether the OLE object is automatically updated when the source changes. Valid only for linked objects (OLE-Type=xlOLELink)

Border

Border

Read-only. Returns the border's properties around the OLE object

BottomRight Cell

Range

Read-only. Returns the single cell range located under the lower-right corner of the OLE object

Enabled

Boolean

Set/Get whether the OLEObject is enabled

Name

Returns

Description

Height

Double

Set/Get the height of OLEObject frame

Index

Long

Read-only. Returns the spot in the collection where the current OLEObject is located

Interior

Interior

Read-only. Returns an object containing options to format the inside area of the OLE object (for example, interior color)

Left

Double

Set/Get the distance from the left edge of the OLEObject frame to the left edge of the sheet

LinkedCell

String

Set/Get the range that receives the value from the results of the OLE object

ListFill Range

String

Set/Get the range that holds the values used by an ActiveX list box

Locked

Boolean

Set/Get whether editing will be possible when the parent sheet is protected

Name

String

Set/Get the name of the OLE object

Object

Object

Read-only. Returns access to some of the properties and methods of the underlying object in the OLE object

OLEType

Variant

Read-only. Returns the type OLE object: xlOLELink or xlOLEEmbed. Use the XlOLEType constants

Placement

XlPlacement

Set/Get how the OLEObject object is anchored to the sheet (for example, free floating, move with cells). Use the XlPlacement constants to set this property

PrintObject

Boolean

Set/Get whether the OLEObject on the sheet will be printed when the sheet is printed

ProgId

String

Read-only. Returns the programmatic identifier associated with the OLE object (for example, "Excel.Application")

Shadow

Boolean

Set/Get whether a shadow appears around the OLE object

ShapeRange

ShapeRange

Read-only. Returns the OLE object as a Shape object

SourceName

String

Set/Get the link source name of the OLE object

Top

Double

Set/Get the distance from top edge of the OLE object to the top of the parent sheet

TopLeftCell

Range

Read-only. Returns the single cell range located above the top-left corner of the OLE object

Visible

Boolean

Set/Get whether the OLEObject is visible

Width

Double

Set/Get the width of the OLE object frame

ZOrder

Long

Read-only. The position of the OLE object among all the other objects on the sheet

+2 0

Post a comment