Sandwich the code in

Application.DisplayAlerts = False
'Your code here
Application.DisplayAlerts = True

Regards,
Alan.
"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.