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