Selecting OK

lackeysl · Mar 27th, 2002, 12:37 PM

How can I auto select the "ok" button with a macro? or How can I turn off the "ok/cancle" verification.

dk · Mar 27th, 2002, 01:17 PM

Without knowing which dialog you're referring to can't say for definite. However, I'd bet a pint that this will work:-

Application.DisplayAlerts=False

'Your code which causes the dialog

Application.DisplayAlerts=True

Excel automatically resets DisplayAlerts back to True anyway at the end of a procedure but it's good practice to do it anyway.

HTH,
D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 12:37 PM	#1
lackeysl New Member Join Date: Mar 2002 Posts: 6	How can I auto select the "ok" button with a macro? or How can I turn off the "ok/cancle" verification.

Mar 27th, 2002, 01:17 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Without knowing which dialog you're referring to can't say for definite. However, I'd bet a pint that this will work:- Application.DisplayAlerts=False 'Your code which causes the dialog Application.DisplayAlerts=True Excel automatically resets DisplayAlerts back to True anyway at the end of a procedure but it's good practice to do it anyway. HTH, D