Cancel the printer setup dialog

[Peter]

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

 

[Vergel Adriano]

Peter,

if it returns false, the user clicked on Cancel.

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

 

[Dave Peterson]

One way:

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

 

[Peter]

It does help - Thankyou.
--
Regards - Peter

Peter,

if it returns false, the user clicked on Cancel.

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