View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JasonK[_2_] JasonK[_2_] is offline
external usenet poster
 
Posts: 18
Default 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