You can use the OLETypeAllowed property to specify the type of OLE object a control can contain.
Setting
The OLETypeAllowed property uses the following settings.
Setting | Constant | Description |
---|---|---|
Linked | acOLELinked (0) | The control can contain only a linked object. |
Embedded | acOLEEmbedded (1) | The control can contain only an embedded object. |
Either | acOLEEither (2) | (Default) The control can contain either a linked or an embedded object. |
You can set the OLETypeAllowed property by using the control's property sheet, a macro, or Visual Basic. You can set the default for this property by using a control's default control style or the DefaultControl method in Visual Basic.
Note For unbound object frames and charts, you can't change the OLETypeAllowed setting after an object is created. For bound object frames, you can change the setting after the object is created. Changing the OLETypeAllowed property setting only affects new objects that you add to the control.
Remarks
To determine the type of OLE object a control already contains, you can use the OLEType property.