Watremarking Excel

[Beesknees]

Does anyone know how to put a watermark on an excel sheet so it prints on each page. I can do it in word by putting it in the header but excel doesn't seem to work the same way. any ideas?

 

[JVFriederick]

This was discussed a few months ago. I would point you to the thread but the search engine is down just now.

I don't think it's possible in Excel, sorry.

 

[ilses]

As JFV says, it is not possible to include a watermark in a header or footer in Excel (not sure about XP though, may well have this often requested feature).

If you have just a few pages in a single sheet, a workaround would be to create a WordArt object, shade it very lightly and put it to the background or make it transparant. You'd have to copy the watermark to all pages. There's a description on the zdnet site somewhere.

Another workaround would be to preprint the paper with the watermark. Officially, doing two print runs on the same paper is supposed to be bad practice.

Finally, it is definitely possible to get watermarks in place on all pages of a sheet with VBA code, perhaps you can find some at the VBA forum.

FWIW

IS

 

[Beesknees]

Thanks for everything. The whole point of this was to write a program that watermark's a spreadsheet and PDF's it thru distiller. The Excel side of this is proving to be a little painful!

 

[Miranda]

How about using word as an interim step? Then you can bring the Excel into Word - format it in Word and then save as PDF...?

Or programmatically include the Word art each time a page break is encountered in Excel.

Ideas only...but it's sure to be possible.

Regards,

Miranda