clipboard message box

J

juli

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

Frank Kabel

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
 
Top