+ Reply to Thread
Results 1 to 4 of 4

Inserting a Picture into Shape Quickly

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    11

    Inserting a Picture into Shape Quickly

    I am working with Excel for Mac 2011.

    In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these?

    If not, can I add a macro to a shape so that it can do what the picture boxes do, opening the folder to select a photo, and put it into excel in the shape, location, and size of the shape?

  2. #2
    Registered User
    Join Date
    06-20-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    11

    Re: Inserting a Picture into Shape Quickly

    With this code from the microsoft website I was able to get the file selection to pop up but was not able to get a .gif or jpeg

    Any ideas on what I would need to change to make this possible?

    Please Login or Register  to view this content.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inserting a Picture into Shape Quickly

    Can you Insert Shape (not smart art), including drawing the shape that you want and then right click the shape, choose to fill with a picture?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    06-20-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    11

    Re: Inserting a Picture into Shape Quickly

    Yes, I can do this, but for the reporting I am doing I need to drop many pictures into the shapes and it takes too long right clicking and going through the folders, I'd like to be able to drop pictures in or have it open to a specific folder.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1