copy and paste and clipboard contents message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am copying and pasting data using a macro. After the data is successfully
copied and pasted i get a message:

Large amounts of data are on the clipboard do you want to be able to paste
this data into a program later?
yes no cancel.

Can i just clear the clipboard in my macro to avoid this message ??? or
circumvent the message?
 
Try the DisplayAlerts Property. This can be used to turn off alerts during
execution. Be sure to set the property to true at the end of the Macro.
 
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
 

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

Macro to restore previous content of clipboard 3
Check if clipboard is empty before pasting 1
Clipboard Message 2
Macro to clear clipboard on exit 2
Managing Cut/Copy & Paste During Program Run 1
Help with Clipboard 1
PasteSpecial method of Range class failed Error 1004 8
Large Amount of Info on Clipboard 2

Back
Top