Print Dialog Cancel Button

[Todd Huttenstine]

Hey guys

When you go to file and print, the print dialog displays.
If the user clicks the cancel button I need for a
particular code I wrote to run. Therefor I need to trap
this event. How do I trap this Cancel click event on the
print dialog screen?


Thank you
Todd Huttenstine

 

[Tom Ogilvy]

Unless your code is displaying it with

res = Application.Dialogs(xlDialogPrint).Show
you don't.

It seems like an unusual situation where you need to react to a user trying
to print using the menus and then changing their mind.