Overwrite Prompt with Save As
 

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

Overwrite Prompt with Save As
 

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.

Overwrite Prompt with Save As
 

Thanks Bob. As soon as I saw your answer, I remembered that property. Isn't
it amazing how much we forget!

"Bob Phillips" wrote:

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.