If displayalerts is true, then you should get a warning/prompt if you want
to overwrite the file.

--
Regards,
Tom Ogilvy

Mark Worthington wrote in message
om...
Can anyone please advise me about the correct operation of SaveCopyAs.
I am using it as follows:

MsgBox Application.DisplayAlerts
MsgBox ActiveWorkbook.Path & "\_new\" & ActiveWorkbook.Name
ActiveWorkbook.SaveCopyAs ActiveWorkbook.Path & "\_new\" &
ActiveWorkbook.Name

So DisplayAlerts is True, yet I get no warning when the SaveCopyAs
overwrites the existing (pre-saved) file.

Is this by design, or am I missing something here. Coding in a
FileExists check is no problem, but I would have thought that ANY save
operation would give an overwrite warning by default.

Regards,

Mark