Printing Watermarks in Excel

[TheBionicOrange]

Mornin' (or not depending on where you are !).

I'm trying to use the macro recorder to trap the keypresses necessary to add a watermark to an Excel document.

Under my print driver I have a tab called 'Effects', which allows you to add a watermark, but I presume as this is print driver specific, VBA ignores it with the macro recorder.

Does anyone know of any code I could use to add a watermark to an Excel workbook, or am I asking the impossible ?

Thanks.

Steve.

[MartinSmith]

I would guess that you are better off trying to find developer documentation at the Printer manufacturer's website.

Maybe it will store the printer defaults in the registry, which you can then read, set to what you want, print, and set back again?

[Si_the_geek]

I use WordArt to put in watermarks... works fine for all printers (& I think it can be recorded too!)

[peet]

Format -> Sheet -> Background...

Just make the watermark big enough to cover the page

[TheBionicOrange]

THANKS FOR THE INPUT. ITS NOW A TOSS-UP BETWEEN WORDART AND PRE-DEFINED BACKGROUND.

OH AND YES WORDART IS CAPTURED BY THE RECORDER.

[Si_the_geek]

GOOD