xldialog question

G

Gary Keramidas

is there any way top trap the cancel button when using
application.Dialogs(xlDialogPrinterSetup).Show?
 
P

Peter T

AFAIK all the dialogs return True (OK) or False (Cancel/Esc)

bOK = Application.Dialogs(xlDialogPrinterSetup).Show

Regards,
Peter T
 
G

Gary Keramidas

thanks, worked fine

--


Gary


Peter T said:
AFAIK all the dialogs return True (OK) or False (Cancel/Esc)

bOK = Application.Dialogs(xlDialogPrinterSetup).Show

Regards,
Peter T
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

Open Search and replace dialog 2
xlDialogPrinterSetup 2
Cancel the printer setup dialog 3
On Error Goto 9
XLDialog for setting the Print Area of a worksheet 3
vba - printing code 4
Printing Userforms [Landscape] 1
Macro stops running if date is not in past... 3

Top