Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
suppressing auto-dailog boxes
I have a macro which creates and saves an excel file with a particular name.
If the macro is run again Excel will ask if I want to overwrite the file. Is there any way to suppress the dialog so the file is saved anyway? (If I try to delete the file first, Excel asks whether I want to to delete it - so effectively same problem!). I have several similar situations where I do not want the user to need to intervene, but don't know a way to suppress such dialog boxes. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
suppressing auto-dailog boxes
Precede the save with
Application.DisplayAlerts = False "Chas" wrote in message ... I have a macro which creates and saves an excel file with a particular name. If the macro is run again Excel will ask if I want to overwrite the file. Is there any way to suppress the dialog so the file is saved anyway? (If I try to delete the file first, Excel asks whether I want to to delete it - so effectively same problem!). I have several similar situations where I do not want the user to need to intervene, but don't know a way to suppress such dialog boxes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop a Smart Tag Login Dailog box when excel opens | Excel Discussion (Misc queries) | |||
Auto Adjusting Text Boxes? | New Users to Excel | |||
How to depress confirmation dailog | Excel Programming | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
Question on Input Boxes and Auto-Filter | Excel Programming |