protect for printing

K

Kevin McClement

e-mail me and i can send you an example. there's some VB
involved, but it works like a charm.

Kevin McClement
 
D

Dave Peterson

I'm not sure what Kevin's workbook looked like, but if you right click on the
excel icon to the left of the File option on the menubar, then select view code
and paste this in:

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "uh, uh, uh!"
Cancel = True
End Sub

It'll stop a few people. But if the user opens the workbook with macros
disabled or just disables events, then this won't work.

And don't forget that you should stop copy|paste (so they don't print from
there) and even alt-prt-screens so they can't get pictures of the screen.

(I think this is a losing battle.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top