Transparent image in background

Help!  How do I insert a picture file (jpeg) in a 
spreadsheet so that it is in the background an semi-
transparent when I print the sheet?  Any suggestions 
would be greatly appreciated!

Thanks!
Jay

0
anonymous (74717)
11/3/2003 5:22:08 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
452 Views

Similar Articles

[PageSpeed] 26

Jay,

Sounds like you want a watermark. This is my standard reply

Many examples, but my favourite is at Aaron Blood's website at
http://www.xl-logic.com/pages/formulas.html

Ron de Bruin has a utility at
http://www.rondebruin.nl/files/Watermark.zip

And finally, if you're using Excel 2002, look for "Watermarks using Excel
XP" at this site:
http://cpap.com.br/orlando

--

HTH

Bob Phillips
    ... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay Simmons" <anonymous@discussions.microsoft.com> wrote in message
news:106701c3a22f$02b561f0$a501280a@phx.gbl...
> Help!  How do I insert a picture file (jpeg) in a
> spreadsheet so that it is in the background an semi-
> transparent when I print the sheet?  Any suggestions
> would be greatly appreciated!
>
> Thanks!
> Jay
>


0
bob.phillips (411)
11/3/2003 6:22:51 PM
Hi Jay

Try this for a picture

If you insert a Autoshape to your sheet you can place
a picture in it(change transperancy to your needs)

See debra's site for how to do it with Comments(the same for a Auto shape)
http://www.contextures.com/xlcomments02.html#Picture


-- 
Regards Ron de Bruin
(Win XP Pro SP-1  XL2002 SP-2)
www.rondebruin.nl



"Jay Simmons" <anonymous@discussions.microsoft.com> wrote in message news:106701c3a22f$02b561f0$a501280a@phx.gbl...
> Help!  How do I insert a picture file (jpeg) in a
> spreadsheet so that it is in the background an semi-
> transparent when I print the sheet?  Any suggestions
> would be greatly appreciated!
>
> Thanks!
> Jay
>


0
rondebruin (3789)
11/3/2003 6:32:29 PM
Reply:

Similar Artilces:

drawing anywhere onscreen by using transparent window?
Hi, I am looking for an example of how to create a transparent window that I can position anywhere on the screen and draw to it using the GDI. So basically it would look like I am drawing on the screen over top of everything, but really I am just drawing to my transparent window. Anyone know how to do this and/or know where there is an example of how to do this? Thanks, gman you can make window with WS_POPUP style or use as a parent HWND_DESKTOP. Then override its OnEraseBkgnd and return TRUE - this should stop CWnd from filling background with white color. All drawing do in OnPai...

Tables and banding color in background
I am creating a template where many tables will need to be used. Our standard is to have banding of rows in the table, and when users want to expand the table, I would like them to be able to have the banding automatically occur. This option appears in Word 2007, but does not function well. Has anyone had success with this functionality? Thanks in advance for your help. Color banding can be applied as part of a table style. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "sharon27lily" <sharon27lily@di...

transparencies are printing opaque instead of transparent
All shadows and pictures set on color transparent, transparent gradient, or a certain percentage transparent, are printing opaque instead of transparent. It shows up transparent on the file when I set it, but shows opaque in the print preview mode, and then prints opaque as well. ...

[Outlook 2007] Image resize limited to 66 ratio in HTML
Hello, it seems Outlook 2007 has a weird behavior rendering images in the following circumstances: Having a one-black-pixel gif, we've used it to render borders, as Outlook 2007 doesn't render backgrounds. So we had that kind of code: <img src=3D"http://blabla.com/img/pix.gif" width=3D"140" height=3D"1"/> or <img src=3D"http://blabla.com/img/pix.gif" width=3D"1" height=3D"100"/> For no reason, Outlook rendered each image width or height greater than 66 to 66, breaking the whole page rendering. The solution was t...

Transparent bitmap in dialog box
Hi! I want to display a bitmap in a dialog box. I use the resource editor to specify the bitmap. How can I make the bitmap transparent? For example; all white areas should have the same color as the dialog window. Regards /Anders I remember seeing examples on how to do this but for the life of me I now cannot find them! Try looking at: www.codeproject.com www.codeguru.com Larry "Anders W�hlin" <anders.wahlin@erv.ericsson.se> wrote in message news:bi2div$25b$1@newstree.wise.edt.ericsson.se... > Hi! > > I want to display a bitmap in a dialog box. I use the resou...

Image is not showing in 16 million colors
Hi all, I am trying to load a bitmap using LoadImage ,please create a bitmap with 32*32 and save it it 256 colors. I have attach the code with this. My Display pallette setting is in 16 million colors. This is working fine in 256 color setting. 32*32 is the image width and image height. OnDrawFunction() { typedef unsigned short UINT16; UINT16 *MyDisplayBuffer = (UINT16*)GlobalAlloc (GPTR,32*32*2); m_hBitmap = (HBITMAP)LoadImage(NULL,"C:\\Bitmap1.bmp", IMAGE_BITMAP, 0, 0,LR_LOADFROMFILE | LR_CREATEDIBSECTION | LR_DEFAULTSIZE); CBitmap bmp; bmp.Attach(m_hBitmap); BYTE* D...

How does one post an image file here that contains an image of an
How does one post an image file here that contains an image of an error message on the desktop? b11_ wrote: > How does one post an image file here that contains an image of an error > message on the desktop? Post an image to one of the image hosting sites. For example, this is the HDTune result for my hard drive. http://img69.imageshack.us/img69/6982/hdtunebenchmark500gbst3.png Paul On 23 May 2010, =?Utf-8?B?YjExXw==?= <b11@discussions.microsoft.com> wrote in microsoft.public.windowsxp.general: > How does one post an image file here that contains an...

transparent object does not print out transparent
I have created a circle (with the circle tool) that has varient shading. It's orange in the center and fades out to transparent. I have a second object sitting behind my circle. While I am working on the document, the object appears as I have designed it, but whent I go to print, the object becomes solid and the transparent part becomes white, hiding the second object behind. Can anyone help me figure out how to print it out as a transparent object? Thanks! This is a known bug in Publisher 2002/2003 along with the rest of Office XP/Office 2003. Group the objects together, then ...

Menu Background issue
Good afternoon; I opened Excel and went to Tools/Options and noticed the drop down Option Menu was displaying a white background, rather than the normal light gray. I checked several other drop down menus and noticed the samething. Is there a setting that will restore the background? Thanks in advance John ...

Image with transparent background
Is it possible to have an image on a button in MFC with a transparent background? How do I do this? Also, how are images stored in MFC applications? Are they compiled into the exe? What is the compression like? Maybe you could use this class: http://www.softechsoftware.it/cbuttonst.html Tom "Bart" <xyz@abc.com> wrote in message news:OIMef.18911$lJ.13991@newsfe5-win.ntli.net... > Is it possible to have an image on a button in MFC with a transparent > background? How do I do this? > > Also, how are images stored in MFC applications? Are they compiled into ...

Transparent CStatic on Dialog with image in background
Hi everyone! I'm developing a little program for windows mobile (think problem should be the same for Win32) in MFC and have problems displaying a dialog with an JPEG-image in the background and placing some transparent CStatic's above it. Here is what I dit: BOOL CMyDialog::OnEraseBkgnd(CDC * pDC) { BOOL bRet = CDialog::OnEraseBkgnd(pDC); // draw background image CComPtr<IImagingFactory>pFactory; HRESULT hr = pFactory.CoCreateInstance(CLSID_ImagingFactory); IImage* pImg; hr = pFactory->CreateImageFromFile(_T("\\myBackImage.jpg"), &pImg); RECT a; a.bott...

How to make opup Menu Transparent
Hi All, Can you please let me know how to make CMenu Object popup menu transparent I am able to make window transparent using ModifyStyleEx(WS_EX_TRANSPARENT,0) Thanks Anup I'm not sure the concept is directly supported. If it isn't, you will have to implement a menu-like popup window yourself. joe On Thu, 4 Sep 2008 05:25:55 -0700 (PDT), Matrixinline <anup.kataria@gmail.com> wrote: >Hi All, > >Can you please let me know how to make CMenu Object popup menu >transparent > >I am able to make window transparent using >ModifyStyleEx(WS_EX_TRANSPARENT,0...

Disable Image/Screen Capture
Is it possible to programmatically disable users from capturing an image of a form (e.g. using PrintScreen or Screen Capture software). I know one can regularly clear the clipboard but this does not protect against Screen Capture software that uses GetDesktopWindow() or GetDC (). Any ideas ? AP wrote: > Is it possible to programmatically disable users from capturing an > image of a form (e.g. using PrintScreen or Screen Capture software). > > I know one can regularly clear the clipboard but this does not protect > against Screen Capture software that uses GetDesk...

How to add Image in to the Case Form
I want to add my logo into our case form. Best Regards Hi, Just add an iframe to the form and insert your image. ian. ...

about transparent window
hello I use SetLayeredWindowAttributes API then the other control(Button or EditBox...) all transparent, but I want the control not transparent,Now,I use UpDateLayeredWindow API then I cannot see any control in my window but can respond message(click..),those all not I want.Please help me thank Show code. joe On Thu, 1 Feb 2007 18:40:00 -0800, zola <zola@discussions.microsoft.com> wrote: >hello > I use SetLayeredWindowAttributes API then the other control(Button or >EditBox...) all transparent, but I want the control not transparent,Now,I use > UpDateLa...

Transparent Image
Hi , I'm having bitmapinfoheader and bitmapbits. and i'm using setdibitstodevice function to copy all the data in to the dc. But i want to blt the tranparent bitmap there. can u help me plz Hi, There are numerous samples for this on codeguru or code project. For example http://www.thecodeproject.com/bitmap/cbitmask.asp Andy Mortimer [MS] Please do not send email directly to this alias. This alias is for newsgroup purposes only This posting is provided "AS IS" with no warranties, and confers no rights. OR if you wish to include a script sample in your post please ...

Images in CListCtrl?
Hi. I'm trying to use a CListCtrl with both the small and state images. So far, it mostly works; in each row, I have a custom state checkbox followed by the small images. In this case, the small images are supposed to be arrows or lines that represent a tree structure. (Yes, I'm kludging up a tree/list control combo.) There are four of them stored as bitmaps in a CImageList in this order: an arrow pointing right, an arrow pointing down, a sideways "T"-shaped line for tree items that aren't last in the child list, and another line that's used for the final child it...

Transparent color?
Using Visio 2000 and apparently can't do what I need. I need to overlay one color rectangle on another and set a transparency for the one on top where I can the one underneath. Can this be done with Visio 2003? Transparency was added in Visio 2003. John... Visio MVP Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm Need VBA examples? http://www.mvps.org/visio/VBA.htm Common Visio Questions http://www.mvps.org/visio/common_questions.htm Visio Wishlist http://www.mvps.org/visio/wish_list.htm "SkeeBee" <ntt@brz.com> wrote in message news:%239Gwg...

Change background color of inbound email
In Outlook 2007, I have from left to right, Mail - shows all inbound, sent, and mail folders, the next is my inbox, and the third is the actual email being show that is highlighted in my inbox. My problem is that some email when it is displayed can not be seen due to colors. 90 percent of my email is fine, but some email I can not read because of the font color, or the background color. I want to know how do I change the background color, or font color of a displayed email? A quick trick is to click somewhere in that message and then press CTRL+A. The message will then be shown...

transparent
I have a combo box that I have set the back style properties to be transparent so that if I dont click on the combo box the cells underneath should show through but they don't as the combo box shows as white and not tgransparent. Any clues please? Thanks I find that when I first place a combo box on a worksheet and change its BackStyle to transparent it does become transparent. But after selecting an item in the combo box it forgets it is transparent. This code, placed in the sheet's module (right-click the worksheet tab and pick View Code), seems to help it remember, at lea...

How to get background gradient with two colors I choose
I have PP 2007 with Windows XP. I click Design>Background and get the Format Background window. Then I select Gradient fill. I get a diagonal gold wavy gradient with white as the second color. How do I choose the colors that I want and have the same gradient? The gradient stops are incomprehensible to me, and no matter what I do with them and the colors, I can't get just the two colors I want. How do I get a gradient with two colors of my choosing? It's a terrible interface, isn't it? http://www.echosvoice.com/gradients.htm should explain. (I'm very glad the ...

Image list #2
hi, i am working with GDI+.i want to list images using a list box. images are stored as .gif. can i use CImageList for .gif images? anu .. ...

Transparent bitmap in FlexGrid cell?
I have a bitmap in the resource (IDB_PICTURE). I need to display it on a FlexGrid's cell with transparent background. Could someone show me how? This is the only function available to put a picture on a cell CFlexGrid::putref_CellPicture(LPDISPATCH) Thank you. ...

how do i get the background fill to fit the A4 page?
Having inserted a background colour onto my page on printing the colour falls short of filling the page. I have tried to adjust the pagr frame measurements but was unable to resolve this. jules wrote: > Having inserted a background colour onto my page on printing the > colour falls short of filling the page. I have tried to adjust the > pagr frame measurements but was unable to resolve this. ===================================== It may be a limitation of your printer. Have a look at the following article: "How to find the maximum print area of your printer" http://ed.mv...

Transparencies
Hi All, would it be possible to make the background of a scanned image transparent for a publication? Thanks and regards GB What version Publisher? There is a transparency tool on the picture toolbar, select your image, select the tool and click on the background of the picture. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "admin" <admin@compulogics.com.au> wrote in message news:eehGmB8SFHA.336@TK2MSFTNGP09.phx.gbl... > Hi All, > > would it be possible to make the background of a scanned image trans...