B
BrianG
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?
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?