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
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