Si un(e) spécialiste pouvait me mettre sur la piste................
Sub essai()
For Each s In ActiveSheet.Shapes
If s.Type = 1 Then
tmp = s.TextFrame.Characters.Text
If Err = 0 Then s.Name = s.TextFrame.Characters.Text
End If
Next s
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect([L1:L15], Target) Is Nothing Then
For Each s In ActiveSheet.Shapes
If s.Type = 1 Then s.Fill.ForeColor.RGB = RGB(255, 255, 255)
Next s
On Error Resume Next
ActiveSheet.Shapes(Target).Fill.ForeColor.RGB = RGB(255, 0, 0)
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal T As Range)
If Not Intersect(T, [l1:l15]) Is Nothing And T.Count = 1 Then
For Each s In ActiveSheet.Shapes
If s.Type = 1 Then
s.Fill.ForeColor.RGB = RGB(255, 255, 255)
If s.TextFrame.Characters.Text = T Then s.Fill.ForeColor.RGB = RGB(248, 36, 14)
End If
Next
End If
End Sub