Leith,
Thanks. The code is exactly what i was looking for.
--
dr chuck


"Leith Ross" wrote:


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