Print Protected

[RJ1969]

Hello all,

Where I work, we share printer. I don’t want to ever to accidentally press “print” option or the shortcut print. Did this one time in my other workbook.

I have a workbook that has a confidential information on each every worksheet. This workbook will never be printed by me since it has a confidential on it.

Is there a vba code to protect my workbook to accidentally print to the printer?

Thanks in advance :o)

[Marc L]

Hi !

Cancel the print in the Workbook_BeforePrint event …

[RJ1969]

Hi,
I don't have the vba code yet.
Sorry... I have a minimal knowledge with the code.

Thanks.

[Marc L]

To paste to the ThisWorkbook module :

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

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !