Stop user to print out our file ==>
Posted by LOkman on January 25, 2001 11:08 AM
I have create some workbook for my colleague..but they never
appreciate it..they always take my works, put it in the diskette
and bring it home.They don't care about my feeling and never
thanks me. This is what I like you guys to help me. I don't
want them to have hard copy of my files. So I want this :
Whenever they try to print the pages( e.g I have 3 sheets in my workbook)
a input box will appear and asking them for password. If they
can't give the right password. a msg box will appear and
said"you don't have authorized to keep this file as your hardcopy"
And the printing process will be stop immediately.
Is it possible. I'm thinking of something like
private sub workbook_beforeprint..but I don't know how to do it..
Wiil someone helps me on this. Thanks in advance