HI,
My company got some documentation in Word and Excel format. Hoever, we won't to let the user to save the document and print it out. Can we use Word/Excel VBA to disable the print/save button in this particular document?
If yes, how??
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Problem with using code:
All they have to do is disable macros when the open the file or have their macro security set to high. Either way, the code won't run and your doc isn't protected anyway. And anyone can take a screen shot.
You might be better off inserting light-gray watermarks that say CONFIDENTIAL across the page or something. That way, if they do *steal* it, anyone they show it to will know it's confidential.
As mentioned above, there is no good way of achieving this...
The only way which could really prevent them from using it, is to only distribute the document through the internet, and program the browser to not allow any Save As or Printing. I've seen this with copyrighted pictures on many websites, but have no clue how to do it.
As soon as you will be distributing the file, in Word format, it will be possible for the user to get around VBA protection or other document protection.
well all you want in code here
http://www.mvps.org/word/F
if you got questions on implementation just post here, i see there's one very good VBA expert around besides my lazy self ;)
bruintje --
That link looks good for stopping Word, but doesn't cover Excel.
It makes reference to intercepting events in Word 2000 with some code, and I inferred that you might be able to do the same thing in Excel 2000, but it doesn't provide the code.
In Word, it would be:
==== BEGIN PASTE ====
Private Sub oApp_DocumentBeforePrint(B
Cancel As Boolean)
'Your code here
End Sub
===== END PASTE =====
I tried
Private Sub oApp_DocumentBeforePrint(B
and
Private Sub oApp_WorksheetBeforePrint(
but neither of these have any affect.
Any suggestions?
-- b.r.t.
(Not to piggyback on gorexy's post, I'll gladly post points for you if you can answer this!)
Never mind. I found an answer here:
http://www.experts-exchang
-- b.r.t.
Business Accounts
Answer for Membership
by: bruintjePosted on 2002-10-20 at 02:18:44ID: 7349079
Hello Gorexy,
it has a great limitation, but it can be done with some vba : problem is it's a lot of work and those who want can still save the temporary file that the apps create in their temp directory
others will suggest convert to pdf but i guess you could still save
so if you still want to make it a bit harder we've to come up with some code
:O)Bruintje