OleObject and OleObjects Members

Use the OleObjects collection to add linked or embedded objects . Use the Worksheet object’s OleObjects method to get a reference to this collection. Use the OleObject object to control the location and appearance of a linked or embedded object. The OleObjects collection and OleObject object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Activate

Add 1

Application 2

AutoLoad 2

AutoUpdate

Border 2

BottomRightCell

BringToFront 2

Copy 2

CopyPicture 2

Count 1

Creator 2

Cut 2

Delete 2

Duplicate 2

Enabled 2

Group 1

Height 2

Index

Interior 2

Item 1

Left 2

LinkedCell

ListFillRange

Locked 2

Name

Object

OLEType

OnAction 2

Parent 2

Placement 2

PrintObject 2

progID

Select 2

SendToBack 2

Shadow 2

ShapeRange 2

SourceName 2

Top 2

TopLeftCell

Update

Verb

Visible 2

Width 2

ZOrder 2

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial