copy and paste and clipboard contents message

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

Check if clipboard is empty before pasting 1
Macro to restore previous content of clipboard 3
Macro to clear clipboard on exit 2
Clipboard Message 2
Help with Clipboard 1
clipboard in excel 1
Managing Cut/Copy & Paste During Program Run 1
Routine Interfering with Clipboard 13

Top