Selecting OK

[lackeysl]

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

 

[dk]

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