Returns or sets a value specifying how an object is updated when linked data is modified.
Syntax
object.UpdateOptions [ = number]
The UpdateOptions property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
number | A integer specifying how an object is updated, as described in Settings. |
Settings
The settings for number are:
Constant | Value | Description |
vbOLEAutomatic | 0 | (Default) Automatic. The object is updated each time the linked data changes. |
vbOLEFrozen | 1 | Frozen. The object is updated whenever the user saves the linked data from within the application in which it was created. |
vbOLEManual | 2 | Manual. The object is updated only by using the Update method. |
Remarks
This property is useful for linked objects where other users or applications can access and modify the linked data.
When an object's data is changed, the Updated event is invoked.