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

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
>

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

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
> >