Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Watermarks in Excel
With MS Word (97-2007) you can place a command (see below) in the header or
footer (Ctrl-F9) that will tell your printer with PostScript drivers to put a watermark on the page. Can you issue a PostScript print command in an Excel header or footer? (I don't think so.) If not is there any other way (other than VBA code) to send a PostScript printer command while sending an excel print print request? Thanks Will Example of a command that can be placed in the header or footer of a Word document to place a watermark in each page of the printout. Print \p page " /Wmark (DRAFT) def /WSize 100 def /Wrot 45 def wp$x wp$right sub wp$left add 2 div wp$y wp$top sub wp$bottom add 2 div translate Wrot rotate /Helvetica-BoldOblique findfont WSize scalefont setfont .7 setgray 3 setlinewidth Wmark stringwidth pop 2 div neg WSize .4 mul neg moveto Wmark true charpath stroke |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Watermarks in Excel
Will,
AFAIK the PS formatting will not work. Maybe one of these methods as a workaround: http://www.google.co.uk/search?hl=en...S earch&meta= My Adobe Acrobat v6 supports adding watermarks to a document. If you automated the printing of the PDF through its objects, I suppose you can add the watermark in code - I've never tried. NickHK "Will Fleenor" wrote in message ... With MS Word (97-2007) you can place a command (see below) in the header or footer (Ctrl-F9) that will tell your printer with PostScript drivers to put a watermark on the page. Can you issue a PostScript print command in an Excel header or footer? (I don't think so.) If not is there any other way (other than VBA code) to send a PostScript printer command while sending an excel print print request? Thanks Will Example of a command that can be placed in the header or footer of a Word document to place a watermark in each page of the printout. Print \p page " /Wmark (DRAFT) def /WSize 100 def /Wrot 45 def wp$x wp$right sub wp$left add 2 div wp$y wp$top sub wp$bottom add 2 div translate Wrot rotate /Helvetica-BoldOblique findfont WSize scalefont setfont .7 setgray 3 setlinewidth Wmark stringwidth pop 2 div neg WSize .4 mul neg moveto Wmark true charpath stroke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Watermarks on Excel | Excel Discussion (Misc queries) | |||
how do i place watermarks on excel sheet? | Excel Discussion (Misc queries) | |||
How do I put page numbers as watermarks in Excel | Excel Discussion (Misc queries) | |||
Watermarks | Excel Discussion (Misc queries) | |||
Our Excel 2000 won't let us print watermarks-they don't show up &. | Excel Discussion (Misc queries) |