copy and paste and clipboard contents message

D

dr chuck

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?
 
T

tumbleweed

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.
 
L

Leith Ross

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
Pasting a cell into bookmarked table from excel vba 1
Copy/Paste (Clipboard) Issues 1
Check if clipboard is empty before pasting 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
PasteSpecial method of Range class failed Error 1004 8
Managing Cut/Copy & Paste During Program Run 1
Help with Clipboard 2

Top