Format Picture to appear behind contents in cell
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Format Picture to appear behind contents in cell

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I format a picture so that it appears behind the contents of a cell? My pictures always coverup the cell contents.

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What I really need is an image to appear between the color of a cell and the contents of the cell. Any help?

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I could be wrong, but I don't think you can get the picture to be transparent (or semi-transparent). You can make a "Watermark" -like effect with WordArt on the sheet, but not with a picture.

    One weird idea that may work for you is to copy your cells as a picture and manipulate the image. Possibly even a chart sheet would do it. Here's how:

    1. Select your range.
    2. Hold down the Shift key
    3. Choose the Edit Menu Option
    4. Choose copy picture.
    5. Paste this picture of your data over the original picture.

    I don't follow your second post, so I could be totally misreading your request.

    Bye,
    Jay

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your reply Jay - Your first sentence answered my question - I am wanting a picture to be transparant like the Word Art. However, I could not use the word art because I am wanting a logo to appear behind a certain group of cells. You had a great idea with making the cells a picture then pasting, but the contents in my cells are dynamic. Thanks anyways for your help.

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When you say your cells are dynamic do you mean the range size is changing? Much tougher.

    If not, you still might be able to do it through a macro. Create another area for your "report" and include the picture there. When you are ready, have the macro do the hard part for you, copying and pasting to the other area.

    Of course, this is still just an idea. I believe the tinkering with the sizing and the positioning would be a tough task.

    Regards,
    Jay

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I said dynamic, I meant the contents of cells are constantly changing, based on the input by the user. But I like the idea with the macro - I will have to play around with it to see if I can get it to work well.

  7. #7
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check this out. Get your logo and put it in some graphics program, or use Snag-It from http://www.Techsmith.com to get an image of your logo in the approximate desired position that you would want it on your worksheet and then all the white space you'll need to fill up the rest of the worksheet (this is not a GREAT workaround, mind you, but worth a shot maybe). Then format-background with a picture and choose your picture. The image/logo/white space WILL repeat at some point, but perhaps you're only using a certain print area that won't cause a problem for you.
    ~Anne Troy

  8. #8
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ~Anne Troy

  9. #9
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sorry for the late reply, but thanks a lot Dreamboat - I will try that. Schick

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com