Cancel the printer setup dialog
 

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

Cancel the printer setup dialog
 

Peter,

if it returns false, the user clicked on Cancel.

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



--
Hope that helps.

Vergel Adriano


"Peter" wrote:

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

Cancel the printer setup dialog
 

One way:

Dim res As Boolean
res = Application.Dialogs(xlDialogPrinterSetup).Show
MsgBox res


Peter wrote:

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

--

Dave Peterson

Cancel the printer setup dialog
 

It does help - Thankyou.
--
Regards - Peter


"Vergel Adriano" wrote:

Peter,

if it returns false, the user clicked on Cancel.

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



--
Hope that helps.

Vergel Adriano


"Peter" wrote:

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