MrExcel Publishing
Your One Stop for Excel Tips & Solutions

This is trivial but please help......


Posted by denise on January 17, 2002 7:29 PM

I know this is trivial but i appreciate your help....I know this can be done but can't for the life of me remember how! I need the word draft to print in the background of every sheet in my workbook. I tried setting the background for the sheet but it doesn't show up in print! I need to be able to print my worksheets with "DRAFT" inbig letters across the back...

any suggestions? thanks in advance


Posted by Qroozn on January 17, 2002 8:00 PM

its called a watermark...... i'm loking for help

Posted by Tom Urtis on January 17, 2002 8:13 PM

Here's a start

This reminds me of a sometime-ago post, at 13952.html

The word art would need to be played with to achieve the effect you are looking for, such as from the Word Art format dialog, selecting Colors and Lines tab, Fill effects from the Fill drop down menu, and choosing a pattern shade.

HTH

Tom Urtis

Posted by Denise on January 17, 2002 8:36 PM

Qrzoon - thanks I couldn't remember what it was called!! Tom - Well I can see how the Word Art gives the look and feel of a watermark, but I think I need an actual one. I need to be able to input data into the cell over the image...

Posted by Jacob on January 17, 2002 8:45 PM

Hi

Maybe you could have the word art added in the before_print event and then deleted after the page is printed.

HTH

Jacob

Posted by Tom Urtis on January 17, 2002 9:28 PM

Denise,

As a workaround, if you want the underlying cell contents to be visible, try setting the Word Art format to "No Fill" on the Colors and Lines tab. Or, select a light fill color and select the Semi-transparent option.

Tom Urtis

Posted by Drew on January 18, 2002 7:18 AM

Denise,
Not sure if you found this yet?
Try File/Page setup/ then the Options button. There should be an Effects tab with watermark options.
Hope that helps.
Drew