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?