Paste Image into Protected Sheet

[Jason8598]

I have a protected sheet that I would like to be able to paste an image to and resize as needed. There are also several command buttons in the same sheet that I want to remain protected. I know that I can allow editing of objects when I go to protect the sheet, but this will allow someone to edit the command buttons, which I do not want. Is there a way that will allow pasting and resizing of an image and still keep the buttons protected?

 

[VoG]

You can do that in code like this

Sub piccy()
ActiveSheet.Unprotect Password:="abc"
ActiveSheet.Pictures.Insert ("C:\example\pic.jpg")
With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
    .LockAspectRatio = False
    .Top = Range("C3").Top
    .Left = Range("C3").Left
    .Height = Range("C3").RowHeight
    .Width = Range("C3").Width
End With
ActiveSheet.Protect Password:="abc"
End Sub

 

[Jason8598]

Thanks for the help, this worked out perfectly.