software

Hi,

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 resize 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 isnt really an option. Currently, I am selecting all the
images by hold shift and clicking. Then i resize them all using format
picturegt;size tab. This works well.

Except that if i accidently 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. Ive lookin most properties and help but have come
up empty. Anyone know of a way?

John--
joncraver
------------------------------------------------------------------------
joncraver's Profile: www.excelforum.com/member.php...oamp;userid=34390
View this thread: www.excelforum.com/showthread...hreadid=541707Use this macro:

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

In article gt;,
joncraver gt;
wrote:

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

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 quot;Select
Multiple Objectsquot;.

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

Hope this information helps you, let us know!

quot;joncraverquot; wrote:

gt;
gt; Hi,
gt;
gt; I have a spreadsheet that runs a macro that lets me add images to a
gt; spreadsheet from a particular folder and position them following a
gt; particular grid. I use it to make lists of products to be made in a
gt; particular day. But i need to resize the images to fit the grid after
gt; the fact before i can print the list.
gt;
gt; There are over 2000 images in the folder, so modifying the original
gt; images to fit isnt really an option. Currently, I am selecting all the
gt; images by hold shift and clicking. Then i resize them all using format
gt; picturegt;size tab. This works well.
gt;
gt; Except that if i accidently miss-click, i deselect everything and have
gt; to start over. Which can get really frustrating when speed is a
gt; factor.
gt;
gt; I was wondering if there is a way to select all images at once without
gt; click on each one. Ive lookin most properties and help but have come
gt; up empty. Anyone know of a way?
gt;
gt; John
gt;
gt;
gt; --
gt; joncraver
gt; ------------------------------------------------------------------------
gt; joncraver's Profile: www.excelforum.com/member.php...oamp;userid=34390
gt; View this thread: www.excelforum.com/showthread...hreadid=541707
gt;
gt;


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 via
writing the code from scratch)--
joncraver
------------------------------------------------------------------------
joncraver's Profile: www.excelforum.com/member.php...oamp;userid=34390
View this thread: www.excelforum.com/showthread...hreadid=541707joncraver, 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 amp; 2003

quot;joncraverquot; gt; wrote
in message ...
gt;
gt; thanks for the help.
gt;
gt; the macro listed above works fine. thanks
gt;
gt; how exactly do you add a hotkey command to a macro?
gt; (i've only ever made macros with hotkeys through the recorder, not via
gt; writing the code from scratch)
gt;
gt;
gt; --
gt; joncraver
gt; ------------------------------------------------------------------------
gt; joncraver's Profile:
www.excelforum.com/member.php...oamp;userid=34390
gt; View this thread: www.excelforum.com/showthread...hreadid=541707
gt;