View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chas chas is offline
external usenet poster
 
Posts: 40
Default 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.