disabling the printer function

[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

 

[Don Guillett]

use the Before_print event
to exit or whatever you want

 

[Gord Dibben]

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