Sub TailleFixeLargeurCommentaire()
For Each c In ActiveSheet.Comments
'c.Visible = True
NbCarCo = Len(c.Text)
'Texte = c.Text
NewLargeur = 100
'c.Shape.Height = 100 ' Hauteur
'GoTo suite
c.Shape.Fill.ForeColor.RGB = RGB(170, 255, 155)
c.Shape.TextFrame.Characters.Font.Name = "Arial"
c.Shape.TextFrame.Characters.Font.Size = 9
c.Shape.Width = NewLargeur 'largeur
If NbCarCo < 30 Then c.Shape.Height = 100
If NbCarCo >= 30 And NbCarCo < 100 Then c.Shape.Height = 150
If NbCarCo >= 100 Then c.Shape.Height = NbCarCo - 50
suite:
c.Shape.Line.Transparency = 0# 'degré d'opacité de la bordure
c.Shape.Line.ForeColor.SchemeColor = 8 'bordure en noir
c.Shape.Line.Weight = 0.25 'épaisseur de la bordure
Next c
End Sub