EndConnected Property
msoTrue if the end of the specified connector is connected to a shape. Read-only MsoTriState.
MsoTriState can be one of these MsoTriState constants. |
msoCTrue Does not apply to this property. |
msoFalse The end of the specified connector is not connected to a shape. |
msoTriStateMixed Does not apply to this property. |
msoTriStateToggle Does not apply to this property. |
msoTrue The end of the specified connector is connected to a shape. |
expression.EndConnected
expression Required. An expression that returns one of the objects in the Applies To list.
Example
If the end of the connector represented by shape three on myDocument
is connected to a shape, this example stores the connection site number in the variable oldEndConnSite
, stores a reference to the connected shape in the object variable oldEndConnShape
, and then disconnects the end of the connector from the shape.
Set myDocument = Worksheets(1)
With myDocument.Shapes(3)
If .Connector Then
With .ConnectorFormat
If .EndConnected Then
oldEndConnSite = .EndConnectionSite
Set oldEndConnShape = .EndConnectedShape
.EndDisconnect
End If
End With
End If
End With