View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Steve Jones[_3_] Steve Jones[_3_] is offline
external usenet poster
 
Posts: 3
Default 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