ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to show "DRAFT" on print versions of test documents. (https://www.excelbanter.com/excel-discussion-misc-queries/211227-how-show-draft-print-versions-test-documents.html)

chopspop

How to show "DRAFT" on print versions of test documents.
 
Wish to print a document for sharing and ask for opinions and or changes.
Would like to watermark with the word "DRAFT" if possible. Help Please. Thank
you, Bill

Lorne[_2_]

How to show "DRAFT" on print versions of test documents.
 
"chopspop" wrote in message
...
Wish to print a document for sharing and ask for opinions and or changes.
Would like to watermark with the word "DRAFT" if possible. Help Please.
Thank
you, Bill


open excel, press F1 to open help and type "draft" in to the search window.
You will get instructions (which are quite long winded)



chopspop

How to show "DRAFT" on print versions of test documents.
 


"Lorne" wrote:

"chopspop" wrote in message
...
Wish to print a document for sharing and ask for opinions and or changes.
Would like to watermark with the word "DRAFT" if possible. Help Please.
Thank
you, Bill


open excel, press F1 to open help and type "draft" in to the search window.
You will get instructions (which are quite long winded)


Thank you, Bill


tyger

How to show "DRAFT" on print versions of test documents.
 
If this is in Word, all you have to do is go to the Insert tab, Quick Parts,
and go into the building blocks gallery. You can choose a watermark (Draft,
Confidential, Do Not Copy, etc.). I hope this helps.

"chopspop" wrote:



"Lorne" wrote:

"chopspop" wrote in message
...
Wish to print a document for sharing and ask for opinions and or changes.
Would like to watermark with the word "DRAFT" if possible. Help Please.
Thank
you, Bill


open excel, press F1 to open help and type "draft" in to the search window.
You will get instructions (which are quite long winded)


Thank you, Bill


Steve Jones[_3_]

How to show "DRAFT" on print versions of test documents.
 
I don't know whether or not this will help you.

Create "Draft" in what ever format you like in a text box.

Create two macros and attached them to a button on your spreadsheet. You can
the display "Draft" at anytime.

Sub draft()

ActiveSheet.Shapes("Text Box 1").Visible = False

End Sub


Sub draftv()

ActiveSheet.Shapes("Text Box 1").Visible = True

End Sub




"chopspop" wrote in message
...
Wish to print a document for sharing and ask for opinions and or changes.
Would like to watermark with the word "DRAFT" if possible. Help Please.
Thank
you, Bill




All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com