EDIT.OBJECT

Macro Sheets Only

Equivalent to choosing the Edit command from the (selected object) Object submenu on the Edit menu. Starts the application associated with the selected object and makes the object available for editing or other actions.

Syntax

EDIT.OBJECT(verb_num)

Verb_num is a number specifying which verb to use while working with the object, that is, what you want to do with the object.

• The available verbs are determined by the object's source application. 1 often specifies "edit, " and 2 often specifies "play" (for sound, animation, and so on). For more information, consult the documentation for the object's application to see how it supports object linking and embedding (OLE).
• If the object does not support multiple verbs, verb_num is ignored.
• If verb_num is omitted, it is assumed to be 1.

Remarks

Your macro pauses while you're editing the object and resumes when you return to Microsoft Excel.

Related Function

INSERT.OBJECT Creates an object of a specified type

List of Command-Equivalent Functions