Results 1 to 3 of 3

Thread: How to select all images in spreedsheet at once in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    How to select all images in spreedsheet at once in Excel

    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 isn’t really an option. Currently, I am selecting all the images by hold shift and clicking. Then i resize them all using format picture>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. I’ve looking most properties and help but have come up empty. Anyone know of a way?

  2. #2
    Join Date
    Aug 2011
    Posts
    564

    Re: How to select all images in spreedsheet at once in Excel

    According to my information you must try to make use this macro:
    Public Sub SelectAllPics()
    ActiveSheet.Pictures.Select
    End Sub
    May be this will help you out.

  3. #3
    Join Date
    Jul 2011
    Posts
    440

    Re: How to select all images in spreedsheet at once in Excel

    There is also a simple way to select all objects within 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!

Similar Threads

  1. How to select multiple text box at a time in Microsoft Excel
    By DEvOTeEL in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 04:59 PM
  2. How to select several Thumbnail Images in DHTML
    By NGV BalaKrishna in forum Software Development
    Replies: 4
    Last Post: 04-02-2010, 03:59 AM
  3. Select a range of sheets in Excel VBA
    By RyanInt in forum Software Development
    Replies: 6
    Last Post: 16-01-2010, 11:47 AM
  4. Excel - Select Switch Command keeps running
    By wuuhaahaa in forum Windows Software
    Replies: 1
    Last Post: 22-10-2009, 11:31 PM
  5. How to select Excel cell without mouse
    By Nathen in forum Windows Software
    Replies: 3
    Last Post: 15-07-2009, 10:42 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,621,903.16118 seconds with 17 queries