Multiple Images in one single column

[Vank]

Hi everybody, I'm totally new to Excel and to this forum. Thanks in advance for any help!

I'm building an inventory and I need to add a batch of images (150+) in one single column, starting from cell A7. I don't need to match the image files with file names, just need to insert the group of images automatically.

Images size / cell size are already matching (3cm, images are square). I only need the images to fill in every cell (starting in A7) and being locked or attached to the cell (so if I add a column or a row, the cell moves and the image does it too).

I've been all day looking for a code or help on the internet, on diverse forums and websites. The macros I've found have not worked or given error.

I'm using Excel for Mac 2011.

Thank you for your time and help!

V

[dilipandey]

HI Vank,

Though I have Excel 2010 on windows 7 OS, but below is what I have done and it seems to be working.. right click on picture -> format picture->properties tab -> checked the options " dont move or size with cells" ... now the picture is not leaving it's place when I inserted rows and columns around that. Suggest you to try something similar in your machine.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

This is the file I tried with:-

image locked.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

This is the file I tried with:-

Attachment 196781


Regards,
DILIPandey

<click on below 'star' if this helps>