You might like to add this to your macro before closing the workbook:

Application.DisplayAlerts = False

This will suppress the error message. Then turn it back on again with
this:

Application.DisplayAlerts = True

Hope this helps.

Pete

On Nov 12, 1:09*am, dhstein wrote:
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.