Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code to handle printing and setting a flag to
confirm printing... Application.Dialogs(xlDialogPrint).Show 2, 1, 3, PrintQty, , , , , , , , , , , True strPrinted = "Y" 'Set Printed flag to "Y" I need to capture the return code so as not to set the flag if the print is cancelled. I tried dlgAnswer = Application.Dialogs(xlDialogPrint).Show 2, 1, 3, PrintQty, , , , , , , , , , , True but the result is a Compile error (expected end of statement after "Show"). Can anyone offer any suggestions on how to capture a cancel of the print dialog and still set the default print of 2 copies, collated? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Dialog Box | Excel Worksheet Functions | |||
open print dialog (File --- Print...) | Excel Programming | |||
printing multiple print areas with a print dialog box | Excel Programming | |||
Print Dialog Box | Excel Programming | |||
return a value from a dialog box | Excel Programming |