If you'd like to prevent anyone from printing your workbook, this code will do the trick (subject to the caveat below).
- If someone disables macros, your code will not run
These macros have been tested with Excel 2010, but should also work in Excel 97 and higher without any modifications.
Prevent Printing Any Worksheet In A Workbook:
The following code will prevent printing any worksheet in the workbook, and goes in the ThisWorkbook module. (If you need help with this, click here.)
Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub