Inserting "Draft" in spreadsheet

[MD]

How can I insert the text "Draft" in the background of a
spreadsheet and still enable the user to enter text in the
cells which will appear on top of the "Draft" text when
viewed and printed?

 

[Ron de Bruin]

Hi MD

You can use Word Art, remove the lines, color with 25% gray, click
semi-transparent (or in latest version set the transparency to your desire).
Rotate to desired angle. On the screen, when you type over the mark, it
looks a bit fuzzy but prints out wonderfully

If you have many to do try this:

Here is some code from L. Howard Kittle.

In this Zip file you can find 4 example workbooks with code to insert watermarks in to your pages.

1 : Watermark Horizontal LANDSCAPE
2 : Watermark Horizontal PORTRAIT
3 : Watermark Vertical LANDSCAPE
4 : Watermark Vertical PORTRAIT

You can download it here.

http://www.rondebruin.nl/files/Watermark.zip

And see this sites also

Aaron Blood's website at
http://www.xl-logic.com/pages/formulas.html

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

 

[MD]

Excellent! Thanks so much - that works perfectly!!

-----Original Message-----
Hi MD

You can use Word Art, remove the lines, color with 25% gray, click
semi-transparent (or in latest version set the transparency to your desire).
Rotate to desired angle. On the screen, when you type over the mark, it
looks a bit fuzzy but prints out wonderfully

If you have many to do try this:

Here is some code from L. Howard Kittle.

In this Zip file you can find 4 example workbooks with

code to insert watermarks in to your pages.

1 : Watermark Horizontal LANDSCAPE
2 : Watermark Horizontal PORTRAIT
3 : Watermark Vertical LANDSCAPE
4 : Watermark Vertical PORTRAIT

You can download it here.

http://www.rondebruin.nl/files/Watermark.zip

And see this sites also

Aaron Blood's website at
http://www.xl-logic.com/pages/formulas.html

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"MD" <[email protected]> wrote in

message news:[email protected]...

 

[Gord Dibben]

MD

Here's a copy of a reply to this subject from Ron de Bruin,

--------------------------------------------------

You can use Word Art, remove the lines, color with 25% gray, click
semi-transparent (or in latest version set the transparency to your
desire).
Rotate to desired angle. On the screen, when you type over the mark, it
looks a bit fuzzy but prints out wonderfully

If you have many to do try this:

Here is some code from L. Howard Kittle.

In this Zip file you can find 4 example workbooks with code to insert
watermarks in to your pages.

1 : Watermark Horizontal LANDSCAPE
2 : Watermark Horizontal PORTRAIT
3 : Watermark Vertical LANDSCAPE
4 : Watermark Vertical PORTRAIT

You can download it here.

http://www.rondebruin.nl/files/Watermark.zip

Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)


End Ron's posting.....................

Gord Dibben Excel MVP