Application.DisplayAlerts = False
' code the would evoke the message

Application.DiplayAlerts = True

--
Regards,
Tom Ogilvy

"Jason Griesbach" <Jason wrote in
message ...
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?