excel display alert

[Craig]

When using a macro to edit and replace an existing file,
Excel displays an alert prompting the user to select Yes,
No, or Cancel to replace that file. No is the default
(black background) button. I would like to change the
default button to Yes. Any ideas? Thanks

 

[BrianB]

Why bother asking the user ?

You can stop the alert with
Application.DisplayAlerts = False (reset to True later).
and force your own Save or SaveA