application.DisplayAlerts = False
' code that causes prompt
Application.displayAlerts = True

this works.
--
Regards,
Tom Ogilvy

"JasperBlaas"
wrote in message
...

I have a macro that, among other things, saves a worksheet with a
specific name. Everytime the macro is run I get the standard dialog box
"do you want to replace the existing file". I am looking for away to
replace the file without the dialog box popping up, so the user won't
have to interfere.

Thanks in advance,

Jasper Blaas


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile:
http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=400776