If you have Excel 2003, di the following steps.
1) Open Under the File Menu select Page Setup
2) On the right side of the dialog bos you will see three buttons, Print,
Print Preview, and Options. Click on Options.
3) Click on the "Effects" Tab
4) On the right side there is a section that says "Watermarks" there is a
drop down menu with four options, None, Confidential, SAMPLE, Draft
There is also a "Edit" Button that will allow you to change the Font,
Message and color of the water mark.
"Ron de Bruin" wrote:
Hi Howard
Bob add it to his watermarks page with your name.
http://www.xldynamic.com/source/xld.xlFAQ0005.html
Good link to send people to I think
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"L. Howard Kittle" wrote in message ...
If you have many to do, I have written code to insert watermarks for many
pages, ( 1 to ?) either landscape or portrait and horizontal vertical page
alignment.
If you would like I can send you the coded workbooks, or I could include the
four macros in a reply to your message.
Or you could go to Ron de Bruin's site here for the same code which he was
kind enough to add it to.
http://www.rondebruin.nl/files/Watermark.zip
HTH
Regards,
Howard
"Newbie" wrote in message
...
I have made up a sample spreadsheet in Excel 2000 and want to have sample
across it but lighter so you can see the writing beneath (or on top of)
it.
Any idea how I can do this?