Sub auto_open()
Dim chemin$, rep$, c As Range, cm As Comment, nom
Dim pict As IPictureDisp
chemin = "D:\Divers\Images XLD\" ' Adapter
nom = InputBox("Entrer le nom de l'image recherchée")
rep = chemin & nom & ".gif"
If nom <> 0 And Dir(rep) <> "" Then
Set pict = LoadPicture(rep)
Set c = ActiveCell
c.ClearComments
c.AddComment
Set cm = c.Comment.Shape.Parent
cm.Shape.Name = nom
c.Offset(0, 1) = cm.Shape.Name ' c.Offset(0, 1) à changer
c.Comment.Shape.Fill.UserPicture rep
c.Comment.Shape.Height = pict.Height / 45
c.Comment.Shape.Width = pict.Width / 55
End If
End Sub