Restrict Printing of Document

  • Thread starter Thread starter SusanThib
  • Start date Start date
S

SusanThib

I would like to protect a document so that it can be
viewed only: not altered and not printed. Any tips?
 
right click on the ThisWorkbook icon to the left of FILE>view code>insert
this>SAVE

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
 
For the printing: Don't try.

Anything you can do would involve macros. And they can be bypassed pretty
easily.

For the protection:
tools|protection|protect sheet
with all the cells locked

But this isn't reliable either. There's code posted here every day/week that
would unprotect the worksheet.

Excel just isn't made for this kind of security.

(Although, I've seen some posts discussing Intellectual Property enhancements in
xl2003. I don't know what that means or how to implement it, though.)
 
SusanThib said:
I would like to protect a document so that it can be
viewed only: not altered and not printed. Any tips?
Click to expand...

On any machine connected to a printer and having a Print Screen facility,
anything that can be viewed can be printed.
 
Back
Top