I want to be able to lock an excel file so that no one can print it, but they
can view the data. Is there a way to do this?

Good afternoon Tim

Use something like this in the ThisWorkbook pane of the VBE:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
MsgBox "You can't print this spreadsheet"
End Sub

It will stop printing but it won't stop users being able to copy and
paste to another workbook to print, using the PrtScr button to collect
screen dumps etc.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=502948

I should add this is with office 2000/excel 2000

"Tim" wrote:

I want to be able to lock an excel file so that no one can print it, but they
can view the data. Is there a way to do this?

Dominic,

Thanks! That should do the trick..

"dominicb" wrote:


Good afternoon Tim

Use something like this in the ThisWorkbook pane of the VBE:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
MsgBox "You can't print this spreadsheet"
End Sub

It will stop printing but it won't stop users being able to copy and
paste to another workbook to print, using the PrtScr button to collect
screen dumps etc.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=502948