How to choose all images at a time in Microsoft Excel Spreadsheet

[NardO]

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.

[AnitG]

There is a macro you can use for the purpose :

Public Sub SelectAllPics()
ActiveSheet.Pictures.Select
End Sub

[Koman]

There is also a simple way to select all objects with in your worksheet. There is a button called Select Multiple Objects, which is not displayed by default in Drawing Toolbar. In the end of drawing toolbar click the arrow and use Add Remove Button option expand the Drawing toolbar list and make a check mark on "Select Multiple Objects". This feature can be used to Select All or Particular objects. Hope this information helps you, let us know.