clipboard message box

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

Guest

I get a message box when copying from one workbook to another via a macro saying that there is a large amount of data and do I want to keep it for use at another time

How do I disable this message?
 
Hi
try adding the line
application.displayalerts = false
before this copy statement
and the line
application.displayalerts = true
afterwards
also add the line
application.cutcopymode = false
 
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

Excel 2003 - VBA - Eliminate Clipboard Message 2
Excel 2003 Clipboard Question 6
macros 3
Macro stops with "Large Amount of Data" Message 3
Excel 2003 - VBA - Kill Clipboard Message 1
Large amount of info on the clipboard 2
Get rid of Information message 3
clipboard 1

Back
Top