Application.DisplayAlerts = False

turn back on if doing anything else


--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Marie Bayes" wrote in message
...
I've written a macro which saves a file with a pre existing name, how can
I
make the macro say Yes to overwrite the file that already exists?

Any help gratefully received. Thanks in advance.