protect printing

J

J.E. McGimpsey

You could put this macro in the ThisWorkbook module, but it's easily
bypassed (by holding down the shift key on startup). And it doesn't
prevent the user from copying a sheet and pasting it into another
workbook - generally, you should assume that if a user can open your
workbook, that they have free access to your data and can print,
copy , save, etc. at will.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
 

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