View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianG[_3_] BrianG[_3_] is offline
external usenet poster
 
Posts: 20
Default Print dialog return help needed

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?