1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| Sub RelierTrombines()
'J.P septembre 2016
Dim conn(4) As Shape
Dim i As Integer
Worksheets("Trombi").Activate
i = 1
' on crée un connecteur de type "en angle"
Set conn(i) = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 1, 1, 1, 1)
' on relie l'image Image01 à l'image Image02 par le connecteur créé
conn(i).ConnectorFormat.BeginConnect ActiveSheet.Shapes("Image01"), 1
conn(i).ConnectorFormat.EndConnect ActiveSheet.Shapes("Image02"), 1
'on colore le connecteur en rouge
conn(i).Line.ForeColor.RGB = RGB(255, 0, 0)
' épaisseur de trait du connecteur
conn(i).Line.Weight = 4
'redessine le connecteur
conn(i).RerouteConnections
i = i + 1
Set conn(i) = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 1, 1, 1, 1)
conn(i).ConnectorFormat.BeginConnect ActiveSheet.Shapes("Image02"), 1
conn(i).ConnectorFormat.EndConnect ActiveSheet.Shapes("Image03"), 1
conn(i).Line.ForeColor.RGB = RGB(255, 0, 0)
conn(i).Line.Weight = 4
conn(i).RerouteConnections
i = i + 1
Set conn(i) = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 1, 1, 1, 1)
conn(i).ConnectorFormat.BeginConnect ActiveSheet.Shapes("Image03"), 1
conn(i).ConnectorFormat.EndConnect ActiveSheet.Shapes("Image04"), 1
conn(i).Line.ForeColor.RGB = RGB(255, 0, 0)
conn(i).Line.Weight = 4
conn(i).RerouteConnections
i = i + 1
Set conn(i) = ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 1, 1, 1, 1)
conn(i).ConnectorFormat.BeginConnect ActiveSheet.Shapes("Image04"), 1
conn(i).ConnectorFormat.EndConnect ActiveSheet.Shapes("Image05"), 1
conn(i).Line.Weight = 4
'bleu
conn(i).Line.ForeColor.RGB = RGB(0, 0, 255)
conn(i).RerouteConnections
End Sub |
Partager