disabling the printer function

  • Thread starter Thread starter Jens Letnes
  • Start date Start date
J

Jens Letnes

Hello,
Is it possible to disable the printer on a certain
spreadsheet in excel (like how you can password protect,
etc...). I want people to be able to open a spreadsheet
and look at it, but not be able to modify or print it.

Thanks,
Jens
 
Jens

I enclose quoted text from a posting of J.E. McGimpsey

Start quote.............

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

End quote.....................

As John points out, Excel is not very secure from the more than casual user.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top