Printing Background in Excel - ie "DRAFT" 1

[cresbydotcom]

Excel 2002, Win XP

We are trying to get the word "DRAFT" splashed across a spreadsheet printout.

Watermark doesn't seem to be offered (that I can see) in Excel and Background is non printing.

I could try looking in VBA and see if the sheet has a property but there is nothing in any menu that I can find.

Any ideas fellow 'Tippers?

there is a tide in the affairs of man that you Cnut ignore.................

 

[GlennUK]

Excel doesn’t actually have a watermark option. Here are a couple of references that will allow you to mimic a watermark in excel.

http://office.microsoft.com/en-us/assistance/HP012138021033.aspx

http://techrepublic.com.com/5100-1035_11-5029907.html#

And here is a page that shows how to using VBA;

http://www.codetoad.com/vba_watermark.asp

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[cresbydotcom]

properties in VBA have not revealed anything yet

eg
activeworkbook.builtinproperties
activesheet
sheets(1)

etc

VBA is not the problem an I vainly tried to use it for solution. Now for you links. TIA

there is a tide in the affairs of man that you Cnut ignore.................

 

[cresbydotcom]

The microsoft link does the job.

All I needed was to pick someone else's brains.

Basically I have to include a picture in the header (or footer)

and to keep it consistent I now also include the same pic as background for on-screen reminders.

'ere have a gold star.

there is a tide in the affairs of man that you Cnut ignore.................

 

[cresbydotcom]

Now embodied in a macro to add or remove.

We do have a pedantic customer and we need to alert them (him) to the provisional nature of the documents.

there is a tide in the affairs of man that you Cnut ignore.................

 

[GlennUK]

Glad that has helped. :-D



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.