I am afraid I have to disagree, but apparently you and Howard don't make
such errors. I make them all the time. I stand in awe.

--
Regards,
Tom Ogilvy

"Mike Fogleman" wrote in message
...
I don't consider True to be a typo for False. "Fakse" is a typo for False.
True is just wrong.
"Tom Ogilvy" wrote in message
...
When the displayalerts property is set to True, Excel does not make a
selection - you do. So the statement is correct as written except the
last
word should be False. An obvious typo.

--
Regards,
Tom Ogilvy



"Howard Kaikow" wrote in message
...
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?
--
http://www.standards.com/; See Howard Kaikow's web site.