Roedd <<Howard Kaikow wedi ysgrifennu:

The Help for DisplayAlerts in Excel 2003 states:


"The default value is True. Set this property to False if you don't
want to be disturbed by prompts and alert messages while a macro is
running; any time a message requires a response, Microsoft Excel
chooses the default response.

If you set this property to False, Micorosoft Excel sets this
property to True when the code is finished, unless you are running
cross process code.

When using the SaveAs method for workbooks to overwrite an existing
file, the 'Overwrite' alert has a default of 'No', while the 'Yes'
response is selected by Excel when the DisplayAlerts property is set
equal to True."


However, when I set DisplayAlerts=False, the opposite effect occurs
when I use SaveAs, which is what I want.

Is the documentation wrong?

The programming default has been different to the GUI default for SaveAs for
as long as I have been using it (over ten years). So it looks like the
documentation (which is *really* badly written - how many times did you have
to read it to get its meaning?) is wrong.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.