How do I make a macro automatically select Yes when a yes/no box appears?
 

I run a macro that replaces cells, and it stops and asks, "do you want
to replace the contents of the destination cells?"

i would like to make it automatically select yes.

is this possible?

thanks in advance.
jasonk

How do I make a macro automatically select Yes when a yes/no box appears?
 

Hello
Use:
Application.AlertBeforeOverwriting = False

HTH
Cordially
Pascal

How do I make a macro automatically select Yes when a yes/no box appears?
 

That didn't work. it still shows me yes / no and stops running. I need
it to select yes and keep on running.

TIA






On Mon, 3 Apr 2006 11:25:25 +0200, "papou" <cestpasbon@çanonplus
wrote:

Hello
Use:
Application.AlertBeforeOverwriting = False

HTH
Cordially
Pascal

How do I make a macro automatically select Yes when a yes/no box appears?
 

Try
Application.DisplayAlerts = False

and remember to set it back to True when you're finished

HTH
Cordially
Pascal

How do I make a macro automatically select Yes when a yes/no box appears?
 

On Mon, 3 Apr 2006 15:33:00 +0200, "papou" <cestpasbon@çanonplus
wrote:

Application.DisplayAlerts = False

Thanks a ton. it worked perfectly that time.
excellent.