Auto-Click Save on Clipboard

S

sowetoddid

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
 
G

Gord Dibben

Application.CutCopyMode = False

Place this line after the Paste operation in your code.

Gord Dibben Excel MVP
 
Top