Auto-Click Save on Clipboard

  • Thread starter Thread starter sowetoddid
  • Start date Start date
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
 
Application.CutCopyMode = False

Place this line after the Paste operation in your code.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Large Amount of Info on Clipboard 2
Check if clipboard is empty before pasting 1
clipboard in excel 1
copy and paste and clipboard contents message 3
how do i empty the clipboard from within an excel macro 5
disable message box during VBA code execution 2
Save sheet bitmap to desktop? 6
Clipboard Message 2

Back
Top