Auto-Click Save on Clipboard
 

Is it possible to insert a line of code in the middle of my curren
macro so that this does not appear...


"There is a large amount of data on the clipboard..."

To save it click "Yes", To delete it click "No"


The choice should automatically be "No".


Thanks for any and all help

--
Message posted from http://www.ExcelForum.com

Auto-Click Save on Clipboard
 

Application.CutCopyMode = False

Place this line after the Paste operation in your code.

Gord Dibben Excel MVP

On Tue, 27 Apr 2004 18:48:24 -0500, sowetoddid
wrote:

Is it possible to insert a line of code in the middle of my current
macro so that this does not appear...


"There is a large amount of data on the clipboard..."

To save it click "Yes", To delete it click "No"


The choice should automatically be "No".


Thanks for any and all help.


---
Message posted from http://www.ExcelForum.com/