Printer Setup Dialog Box
 

This works for me...but..Once I do this...

Application.Dialogs(xlDialogPrinterSetup).Show

if the user cancels the dialog box my macro fails. How can I direct the
cancel button back to a point in my macro.





*** Sent via Developersdex http://www.developersdex.com ***

Printer Setup Dialog Box
 

Try what's below. This controls what happens when you press the cancel button.

res = Application.Dialogs(xlDialogPrint).Show
If res = False Then
' dialog cancelled
....[your code]
End If


"Michael Smith" wrote:

This works for me...but..Once I do this...

Application.Dialogs(xlDialogPrinterSetup).Show

if the user cancels the dialog box my macro fails. How can I direct the
cancel button back to a point in my macro.





*** Sent via Developersdex http://www.developersdex.com ***

Printer Setup Dialog Box
 

Try this

pr = Application.Dialogs(xlDialogPrinterSetup).Show
If pr = False Then
' User cancelled
Exit Sub
End If


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michael Smith" wrote in message ...
This works for me...but..Once I do this...

Application.Dialogs(xlDialogPrinterSetup).Show

if the user cancels the dialog box my macro fails. How can I direct the
cancel button back to a point in my macro.





*** Sent via Developersdex http://www.developersdex.com ***