Using VBA to lock pictures to a cell

[Balmer07]

Hi,

I am currently running a sheet where I copy an image into a cell in column 'R', now there can be 1 picture or they could be 10 pictures in that 1 cell. But this sheet is filtered and so I need to lock the picture to the cell so that they stick with the same row and keep the sheet tidy.

Is there some VBA code I can use to lock all pictures in column 'R' to the cell they are currently in?

Currently I have to right click on every picture and lock to cell through properties.

Thanks in advance

Stevie B