Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
joncraver
 
Posts: n/a
Default Selecting all images in spreedsheet at once


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
picturesize 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: http://www.excelforum.com/member.php...o&userid=34390
View this thread: http://www.excelforum.com/showthread...hreadid=541707

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Selecting all images in spreedsheet at once

Hi John,

Yes, there is a way to select all images in your spreadsheet at once. Here's how:
  1. Click on any image in your spreadsheet to select it.
  2. Press "Ctrl" + "A" on your keyboard. This will select all objects in your spreadsheet, including images.
  3. Now, you can resize all the images at once by going to the "Format Picture" tab and adjusting the size as needed.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey
 
Posts: n/a
Default Selecting all images in spreedsheet at once

Use this macro:

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

In article ,
joncraver
wrote:

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
picturesize 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
RajKohli
 
Posts: n/a
Default Selecting all images in spreedsheet at once

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" wrote:


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
picturesize 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: http://www.excelforum.com/member.php...o&userid=34390
View this thread: http://www.excelforum.com/showthread...hreadid=541707


  #5   Report Post  
Posted to microsoft.public.excel.newusers
joncraver
 
Posts: n/a
Default Selecting all images in spreedsheet at once


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: http://www.excelforum.com/member.php...o&userid=34390
View this thread: http://www.excelforum.com/showthread...hreadid=541707



  #6   Report Post  
Posted to microsoft.public.excel.newusers
Paul B
 
Posts: n/a
Default Selecting all images in spreedsheet at once

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

"joncraver" wrote
in message ...

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:

http://www.excelforum.com/member.php...o&userid=34390
View this thread: http://www.excelforum.com/showthread...hreadid=541707



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Images in Excel Larry E Excel Discussion (Misc queries) 2 February 21st 06 05:28 PM
Printing conditional images Trav Excel Discussion (Misc queries) 6 January 12th 06 02:46 AM
stop images exceeding page margins from printing in Excel Wallace Excel Discussion (Misc queries) 2 October 31st 05 12:29 AM
Images will not display GRS&S Excel Discussion (Misc queries) 3 February 16th 05 03:19 PM
Using excel to select only matching images... davidbev008 Excel Discussion (Misc queries) 1 December 3rd 04 07:18 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"