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

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

I'm saving a 2003 excel worksheet in Excel '97 format.
As I use the "save" or "saveAs' macro command, a display
alert pops up asking me if I wish to over-write file
or "that I will lose data in 2003 Excel format. Do I
wish to continue?" Supressing display alerts causes the
program to crash. Looks like I just need to have macro
return "Yes" to the prompt. Don't know how to do this!

Earl
-----Original Message-----
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


.