Hello Dr Chuck,
DisplayAlerts will automatically select the default button on the
dialog. I have never had the dialog you describe be displayed so I
don't which button is the default.
You can try clearing your clipboard before the macro exits by using
this line of code...
Application.CutCopyMode = False
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=554812