Cancel the printer setup dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of a way of detecting the Cancel button from the Printer
Setup dialogue box, as in ... Application.Dialogs(xlDialogPrinterSetup).Show
 
Peter,

if it returns false, the user clicked on Cancel.

If False = Application.Dialogs(xlDialogPrinterSetup).Show Then
MsgBox "User Cancelled"
End If
 
One way:

Dim res As Boolean
res = Application.Dialogs(xlDialogPrinterSetup).Show
MsgBox res
 
It does help - Thankyou.
--
Regards - Peter


Vergel Adriano said:
Peter,

if it returns false, the user clicked on Cancel.

If False = Application.Dialogs(xlDialogPrinterSetup).Show Then
MsgBox "User Cancelled"
End If
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xlDialogPrinterSetup 2
xldialog question 2
Printer Setup Dialog Box 2
Printing Userforms [Landscape] 1
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0
vba - printing code 5
Printer Dialogue 1
XLDialog Printer Setup 2

Back
Top