Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a macro automatically select Yes when a yes/no box appears?
Hello
Use: Application.AlertBeforeOverwriting = False HTH Cordially Pascal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Select All Sheets and Make Change to Footer | Excel Discussion (Misc queries) | |||
How can make a macro to run evey one hour-automatically | Excel Discussion (Misc queries) | |||
How to make a macro that automatically starts after clicking a cel | Excel Programming | |||
Make a macro run automatically in Excel 03??? | Excel Programming | |||
How to make excell automatically select every other role for shadi | Excel Worksheet Functions |