1

Topic: How to protect the interposed picture from user, but to leave editing VBA

MS Excel 2003 .
The sheet is protected by the password.
At sheet start I open access to operation with cells means VBA a command

Sheets (1).Protect Password: = "123", UserInterfaceOnly: = True

Into a cell a command I interpose a picture.

Sheets (1).Pictures. Insert ("C:\myPic.jpg")

Then the picture should be deleted. I delete a command

With sheets (1)
.Pictures. Delete
'.DrawingObject. Delete
'.Shapes. Delete
End With

But the picture is not deleted. Errors any it is not produced, simply the picture remains on a place. If manually to remove protection, the picture program is deleted.
The Question: how to organize that a picture it would be possible to delete program on the protected sheet?

2

Re: How to protect the interposed picture from user, but to leave editing VBA

abwabw wrote:

If manually to remove protection, the picture program is deleted

Try to remove program protection, to delete a picture, to install protection.