I have a spreadsheet that runs a macro that lets me add images to a spreadsheet from a particular folder and position them following a particular grid. I use it to make lists of products to be made in a particular day. But i need to re-size the images to fit the grid after the fact before i can print the list. There are over 2000 images in the folder, so modifying the original images to fit isn't really an option. Currently, I am selecting all the images by hold shift and clicking. Then i re-size them all using format picture > size tab. This works well. Except that if i accidentally miss-click, i deselect everything and have to start over. Which can get really frustrating when speed is a factor. I was wondering if there is a way to select all images at once without click on each one. I have looking most properties and help but have come up empty. Anyone know of a way.
Bookmarks