Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Alert Before Overwriting Message Box
In a macro I save a workbook which overwrites another. The problem is every
time the macro is excuted, I get a message box asking if I want to overwrite the existing file. Is there a way to turn this message off? I've tried placing the following in my macro, but it has no effect: Application.AlertBeforeOverwriting = False |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Alert Before Overwriting Message Box
Try preceding with
Application.DisplayAlerts = False and set back to True afterwards -- HTH Bob Phillips (remove nothere from email address if mailing direct) "JR_06062005" wrote in message ... In a macro I save a workbook which overwrites another. The problem is every time the macro is excuted, I get a message box asking if I want to overwrite the existing file. Is there a way to turn this message off? I've tried placing the following in my macro, but it has no effect: Application.AlertBeforeOverwriting = False |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off Alert Before Overwriting Message Box
That works. Thanks
"Bob Phillips" wrote: Try preceding with Application.DisplayAlerts = False and set back to True afterwards -- HTH Bob Phillips (remove nothere from email address if mailing direct) "JR_06062005" wrote in message ... In a macro I save a workbook which overwrites another. The problem is every time the macro is excuted, I get a message box asking if I want to overwrite the existing file. Is there a way to turn this message off? I've tried placing the following in my macro, but it has no effect: Application.AlertBeforeOverwriting = False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off Excel alert | Excel Discussion (Misc queries) | |||
how to turn off alert when accessing a hyperlink in excel - | Excel Discussion (Misc queries) | |||
Alert Message | Excel Discussion (Misc queries) | |||
Alert before overwriting cells | Excel Discussion (Misc queries) | |||
Overwriting error message #NUM! with meaningful text | Excel Discussion (Misc queries) |