View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_591_] Leith Ross[_591_] is offline
external usenet poster
 
Posts: 1
Default copy and paste and clipboard contents message


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