BeforePrint event handler activeworkbook

[dohc46]

Hello,
I don't understand why it appears that event handlers are only good for one workbook, meaning...

At work the printer adm group defaults the printer to print double side and in black and white. I want a message box to pop up regardless of what workbook I want to print reminding me to change settings if I want to.

This code works fine ONLY IF I am printing from this workbook in which the code is in. How can I get this code to work, regardless of what workbook I want to print? Thank you. (this concept/answer - probably useful for other event handlers I would guess).

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim msgresponse

    msgresponse = MsgBox("Did you remember to change printer default settings: color & double sided?", vbYesNo)
   
    If msgresponse = vbNo Then Cancel = True

End Sub

 

[Jaafar Tribak]

You could sink the workbooks events at the application level. If you place that in an addin, the event sinking remains functional throughout the use of the excel application.

Do a search for "Application Events" , "WithEvents" keywords.