Une première proposition à adapter le chemin + Nom + redimension :
Sub image()
ActiveSheet.Unprotect
ActiveSheet.Pictures.Insert("C:\xxx\xxxx\Pictures\thumb-1920-676442.png" _
).Select
Selection.ShapeRange.ScaleWidth 0.3461603237, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.3461603397, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.Left = 80
Selection.ShapeRange.Top = 100
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub