Before closing the file, execute the following statement:
Application.CutCopyMode = False
If the problem still continues, which it may, copy a single cell. This will
make the contents of the clipboard very small and thus eliminate the
message.
Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707
Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"dhstein" wrote in message
...
I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there
is a
large amount of data in the clipboard - and I need to click "OK". Is
there a
way to suppress that message so the macro will complete? Thanks.