Application.DisplayAlerts=False
should work okay. How do you use it, what is the code?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Earl" wrote in message
...
How can I respond to a Display Alert using Visual Basic
for Excel? I've tried to use
Applicaiton.DisplayAlerts=False to disabler the alerts,
but the program locks up and closes. Looks like the
easiest way out is to respond to the alert by having my
macro respond 'yes' or 'no'. Can any one tell me how to
write the VB code line to do so? Earl