S SusanThib Dec 18, 2003 #1 I would like to protect a document so that it can be viewed only: not altered and not printed. Any tips?
I would like to protect a document so that it can be viewed only: not altered and not printed. Any tips?
D Don Guillett Dec 18, 2003 #2 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
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
D Dave Peterson Dec 18, 2003 #3 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.)
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.)
H Harlan Grove Dec 18, 2003 #4 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.
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.
