Shape Property

Returns a Shape object or InlineShape object, depending on the Microsoft Office host application. Read-only Object.

Remarks

The Shape property returns a Shape object in Microsoft Excel and PowerPoint. In Word, the Shape property returns a Shape object if the script anchor is floating; if it’s an inline anchor, however, this property returns an InlineShape object.

Example

This example gets the shape associated with the first script in the Scripts collection and deletes it from worksheet one in the active workbook.

Dim objScriptShape As Object

Set objScriptShape = _
    ActiveWorkbook.Worksheets(1).Scripts(1).Shape
ObjScriptShape.Delete