Program Auto Yes for overwriting files

[DKY]

I have a save dialog in one of my macros but since it is overwriting a 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 you 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? Sometimes when I delete a sheet it asks if I'm sure.

[Tom Ogilvy]

Yes.

--
Regards,
Tom Ogilvy


"DKY" <[email protected]> wrote in message
news:[email protected]...
>
> It works, thanks!!! Does that work for Deleting Sheets too? Sometimes
> when I delete a sheet it asks if I'm sure.
>
>
> --
> DKY
> ------------------------------------------------------------------------
> DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
> View this thread: http://www.excelforum.com/showthread...hreadid=542542
>