Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got a button at the bottom of a sheet called 'Print'. Logically one
would only push that button when they really wanted to print the sheet, but some click and are suprised when the print dialog comes up. After a logical person clicks the button on purpose and prints the form a message box asks to verify if the sheet printed before finishing the code. The problem is that if you click cancel in the print dialog the code continues to the print confirmation. I could add a msgbox before opening 'Print' asking if they really want to print, but sometimes people even get past that. Is there any way for me to say: "if cancel button in print dialog is true, then exit sub"? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Controlling Radio Button | Excel Discussion (Misc queries) | |||
Capture a cancel button | Excel Programming | |||
Cancel button | Excel Programming | |||
Option button controlling text box | Excel Programming | |||
Cancel Button | Excel Programming |