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