protect printing

  • Thread starter Thread starter Soe
  • Start date Start date
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

Back
Top