Prevent Printing In A Workbook

If you'd like to prevent anyone from printing your workbook, this code will do the trick (subject to the caveat below).

Macro Weaknesses

  • If someone disables macros, your code will not run


Versions Tested:
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.)

Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Cancel = True
End Sub

Share:

Facebook
Twitter
LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Posts