View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Print Dialog Cancel Button

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.


--
Regards,
Tom Ogilvy


"Todd Huttenstine" wrote in message
...
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