Application.DisplayAlerts = False
'Save
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chip" wrote in message
...
How can I remove the overwrite prompt when I do Save As? I tried SendKeys
"{ENTER}" to defeat it but that doesn't work.