Tom Ogilvy's solution disables the warnings.

when you're done with the CB you can clear the
clipboard with a simple application.cutcopymode=false
before closing the file.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?SmFzb24gR3JpZXNiYWNo?= <Jason
wrote:

I have written a macro that collects data from dozens of data files
into a single workbook. Every time the macro closes one of the data
files I get an automatic message window that says "There is a large
amount of data on the clipboard. Do you want to save for future
applications?" and I must manually click 'no' dozens of times in this
'automatic' macro.

How do I disable this message window so that it doesn't disrupt my
macro?