View Single Post
 
Old 07-22-2014, 08:29 AM
Guloluseus Guloluseus is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Sizing cells to pics (or even vice versa?)

I have a long spreadsheet (Excel 2010) imported from word as a copy and paste (i.e. the original table was in word, I opened word doc, selected all, and pated into excel). There were about 20 original word docs that had to be comined into the one excel sheet.

I have 8 columns, 7 of which are straightforward text, 1 (column D) contains a picture. These vary in size and shape (some square, some long rectangle, some tall rectangle) and were taken from a 3rd source into the sheet.

I have checked in "size and properite/ size, and all pics are set to "move and size with cell".

The question- I need to set all pictures to be locked in size, so they do not scale with cells, and to be able to set the row height to be slightly greater than the pic. I searched for VBA macros that wold help, so far I can only foind ones that assist with importing pics.

Any help would be mch appreciated, if you need more details, let me know.

thanks
Reply With Quote