Restrict Print Function

  • Thread starter Thread starter Lazz
  • Start date Start date
L

Lazz

In MS Excel 2k3 is there a way I can lock down a file so
it can only be viewed, to the point of not being able to
print the file?
If so is this backwards compatible with earlier versions
of MS Excel?

Thanks in advance.

D. Allen
 
This'll stop some people, but not all:

Right click on the excel icon to the left of File (on the menu bar).
Select View Code
Paste this in:

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

But if the user opens the workbook without enabling macros, it breaks. If the
user turns off event handling, it breaks.

Heck, even if they do everything you want them to do, they could still hit
alt-printscr and paste to Word and print from there.

Excel just isn't a secure enough tool to stop the really curious from doing
almost anything.
 
Back
Top