excel display alert

  • Thread starter Thread starter Craig
  • Start date Start date
C

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
 
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
 
Back
Top