Selecting all images in spreedsheet at once

[joncraver]

Hi,

I have a spreadsheet that runs a macro that lets me add images to
spreadsheet from a particular folder and position them following
particular grid. I use it to make lists of products to be made in
particular day. But i need to resize the images to fit the grid afte
the fact before i can print the list.

There are over 2000 images in the folder, so modifying the origina
images to fit isnt really an option. Currently, I am selecting all th
images by hold shift and clicking. Then i resize them all using forma
picture>size tab. This works well.

Except that if i accidently miss-click, i deselect everything and hav
to start over. Which can get really frustrating when speed is
factor.

I was wondering if there is a way to select all images at once withou
click on each one. Ive lookin most properties and help but have com
up empty. Anyone know of a way?

Joh

 

[JE McGimpsey]

Use this macro:

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

 

[Guest]

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 checkmark on "Select
Multiple Objects".

This feature can be used to Select All or Particular objects.

Hope this information helps you, let us know!

 

[joncraver]

thanks for the help.

the macro listed above works fine. thanks

how exactly do you add a hotkey command to a macro?
(i've only ever made macros with hotkeys through the recorder, not vi
writing the code from scratch

 

[Paul B]

joncraver, tools, macro, select your macro, options

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003