Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    MI, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Placing Objects behind the Cells/Text? (XL2000)

    Is it not possible to put an object (image) behind the text in Excel, as can be done with Word?

    I want the placement of an image to be underneath the cells, so that the cell contents can be seen, as well as be selected. I've tried a number of different ways to import the picture, but each time, the object format dialog doesn't have any means for accomplishing that. Using FORMAT | SHEET | BACKGROUND doesn't work either since I only want one instance of the image, plus if my idea works, I may want to have several pictures placed behind the cells/text.

    Otherwise, I may just have to use the image as is and "draw" hotspots to activate a series of combo-/listboxes, but I think this would cause the file size to bloat due to multiple objects. Thanks

    AJF

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Placing Objects behind the Cells/Text? (XL2000)

    See if <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=33875&page=&v iew=&sb=&o=&vc=1#Post33875>This Thread</A> will help.
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    MI, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Placing Objects behind the Cells/Text? (XL2000)

    Legare,
    It was informative for future reference purposes. Once again, another reason why M$ coders need to spend more time "cross training" with other departments, or at least use some version of Xtreme Programming, so that Office becomes more unified from a useability POV.

    I'm not the type that tries to use only Word for a task that could be better done by Excel or vice versa. All the same, each Office apps features little things that the others could use as well. What's the point of watermarking if you can't print it or send it. Oh well. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    Thanks

    AJF

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Placing Objects behind the Cells/Text? (XL2000)

    ActiveSheet.SetBackgroundPicture Filename:= "filename and path" can be used to add/remove a background from a given sheet but like you said the background is only applied to the current sheet and you'd have to use this code to add it to each sheet in the workbook.

    How about using a printer driver that adds watermarks? I LOVE a program called FinePrint (http://www.fineprint.com) and it does watermarks (I mostly use it print multiple pages to one physical page). I'm sure there are other printer drivers that support watermarks too.

    Another idea would be to force a message on the sheet's footer or header when the user prints it. You can add code to the BeforePrint event that writes your text. It'd serve the same purpose as your watermark in that it is always visible on their page.

    I agree with you that the features across Office tools definitely could be more consistent but as with most large companies, groups rarely talk to each other about features to add or how to implement them. I also hate how the same code can work differently in different versions of Excel - AARRGGGHHH!!

    Deb <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  5. #5
    Lounger
    Join Date
    Nov 2001
    Location
    MI, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Placing Objects behind the Cells/Text? (XL2000)

    Deb, thanks for the input. I also use fine print. I'm just frustrated that I can't get the some of the same functionality in Excel that I can get from Word with regards to images.

    AJF

Posting Permissions

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