+ Reply to Thread
Results 1 to 3 of 3

Frame around referenced image

  1. #1
    Registered User
    Join Date
    10-28-2009
    Location
    Massachusetts
    MS-Off Ver
    365
    Posts
    16

    Frame around referenced image

    In the attached file the image in cell F2, which is referenced via a data validation list in cell E2, has a frame around it, whereas the referenced image(s) in column C do not. Is there either a way to hide/remove this frame or is there possibly another method of accomplishing the data validation reference intent where the referenced image does not have a frame? I went through all of the picture formatting features I could find with no success. Thanks. Office 365.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Frame around referenced image

    Please right click at the image > format picture > at Picture tab > Picture correction > increase contrast to 50%

  3. #3
    Registered User
    Join Date
    10-28-2009
    Location
    Massachusetts
    MS-Off Ver
    365
    Posts
    16

    Re: Frame around referenced image

    That solution works if the background/cell color is white, but not when it is other colors. So it worked for the example. But in the picture tab, in addition to Picture Correction, there also is Crop, and crop seems to work for all background/cell colors, so you set me on the right track. Thanks much Bo_Ry!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do i load pictures into the image frame in the worksheet?
    By josaah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2016, 01:03 PM
  2. [SOLVED] Looping through controls by frame on userform (frame within a frame)
    By njs27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 10:21 AM
  3. Shape buttons - Switch background image of shape on click and exit - referenced jpg
    By ApatheticAndrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 08:06 AM
  4. Code to paste image from filename into cell that is referenced?
    By ChristophExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2014, 01:32 PM
  5. [SOLVED] Insert jpg image from file path to image frame
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 10:12 AM
  6. Problem putting a chart into a userform image frame
    By shakey775 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-19-2012, 08:54 AM
  7. How do I have an image in a cell based upon a referenced value?
    By Jonathan Neubauer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2005, 07:06 PM

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