Bonjour le forum et les autres
essaye deci:
Sub Ajust_Commentaires()
Dim Wks As Worksheet, cmt As Comment
For Each Wks In Worksheets
For Each cmt In Wks.Comments
With cmt.Shape.OLEFormat.Object.Font
.name = "Tahoma"
.Size = 8
cmt.Shape.TextFrame.AutoSize = True
End With
cmt.Shape.OLEFormat.Object.ShapeRange.Fill _
.ForeColor.SchemeColor = 22
Next cmt
Next Wks
End Sub