Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
Hi John,
Yes, there is a way to select all images in your spreadsheet at once. Here's how:
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Images in Excel | Excel Discussion (Misc queries) | |||
Printing conditional images | Excel Discussion (Misc queries) | |||
stop images exceeding page margins from printing in Excel | Excel Discussion (Misc queries) | |||
Images will not display | Excel Discussion (Misc queries) | |||
Using excel to select only matching images... | Excel Discussion (Misc queries) |