Wei-Dong -
Thanks for your quick reply. Unfortunately,
Application.DisplayAlerts doesn't seem to be doing the
job either. According to the documentation,
DisplayAlerts can only be used to suppress messages
generated during execution of a macro. The message that
I'm trying to suppress is generated by user action (not
programmatically), and I've been unable to find a way to
suppress it.
Other ideas?
- Jeff Richman
-----Original Message-----
Hi Jeff,
So far a I know, I'd suggest you can set DisplayAlers to
false before you perform the operation.
Application.DisplayAlerts = False
After the operation, you can restore the state to normal
with the codes below:
Application.DisplayAlerts = True
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, Excel will chooses
the default response.
Please feel free to let me know if you have any further
questions.
Does this answer your question? Thank you for using
Microsoft NewsGroup!
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and
confers no rights.
.