Hi
one way is to disable this prompts with
application.displayalerts = flase
and reset them to True at the end of your macro

-----Original Message-----
Can anyone tell me how to respond (from within a macro)
to display prompts requiring a "yes" or "no" answer -
Excel 2000?
How about macro code for a simple "enter key"?

Older versions of Excel allowed an embedded "Y" or "N" in
the macro.

Thanks.


.