Program Auto Yes for overwriting files

[DKY]

I have a save dialog in one of my macros but since it is overwriting
file in a location week after week I get a popup that says

A file named "D6_Panic.xls" already exists in this location. Do yo
want to replace it?

Is there a way to automatically program a yes there in the macro

 

[Die_Another_Day]

before save use this line of code:
application.displayalerts = false

after saving turn it back on with this line of code
application.displayalerts = true

HTH
Die_Another_Day

 

[DKY]

It works, thanks!!! Does that work for Deleting Sheets too? Sometime
when I delete a sheet it asks if I'm sure

 

[Tom Ogilvy]

Yes.