+ Reply to Thread
Results 1 to 13 of 13

How to transparent jpeg in excel?

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    How to transparent jpeg in excel?

    There is jpeg inserted in excel and made transparent by VBA.

    Please Login or Register  to view this content.

    How to make white rectangle in jpeg to transparent so that wording
    under the jpeg can be shown (Pls see attached excel)?
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    By the looks of the image that block is not the same colour and the one used as transparent. If you remove the Contrast it is more a light orange than white.
    You would need to correct the original image so it had the same colour as that chosen for transparency
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    As the original image is from others and hence cannot be changed.

    If the % of Brightness or Contrast is adjusted (only 1%) manually, the
    white rectangle will be transparent and it is what I want.

    How to adjust the % of Brightness or Contrast by VBA?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    Thanks Andy Pope that it works for 1 jpeg.

    How to modify the VBA so that it can apply to all jpegs inserted in excel?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    Thanks Andy Pope that it works.

    As you know that the original image has light orange block,
    how to revise the VBA so that the light orange do not turn white.
    (i.e. light orange and wording can shown at the same time in excel.)

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    Just set the transparency.

    Please Login or Register  to view this content.
    This will leave the solid orange block in place.

  9. #9
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    Hi Andy Pope,

    The 2 codes have already been included in VBA.

    Please advise with full VBA how to show
    orange box and wording at the same place in excel.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    Just remove the other lines you have. Run this on the reset image and you will get transparent with orange block

    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    Hi Andy Pope,

    Your VBA can show orange box but cannot show wording under the box.

    I mean how to show wording with orange box.

  12. #12
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: How to transparent jpeg in excel?

    not possible with the way you have things currently. You can not have a solid colour AND make it transparent.

    You would need to place something, textbox/shape, over the image that linked to the cell below.

  13. #13
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to transparent jpeg in excel?

    Thanks Andy Pope for help with patience.

+ 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. [SOLVED] How to make a transparent picture become not transparent?
    By london7871 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-04-2017, 05:36 AM
  2. EXCEL IS TRANSPARENT
    By kimbcat in forum Excel General
    Replies: 0
    Last Post: 08-05-2006, 01:45 AM
  3. [SOLVED] transparent level/limit in an Excel chart (3D)
    By ju1eshart in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-24-2006, 02:55 PM
  4. Replies: 1
    Last Post: 08-03-2005, 07:05 PM
  5. [SOLVED] Transparent Text in Excel Spreadsheet?
    By Les Coover in forum Excel General
    Replies: 2
    Last Post: 05-03-2005, 08:06 PM
  6. [SOLVED] Using excel to embed multiple transparent links to other excel...
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2005, 06:45 PM
  7. [SOLVED] Excel cross cursor should be transparent when hovering over number
    By Bundaluk in forum Excel General
    Replies: 1
    Last Post: 02-04-2005, 05: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