Application.CutCopyMode = False
will clear the clipboard so you don't get the prompt.

--
Regards,
Tom Ogilvy

wrote in message
...
I was trying to close a workbook the other day after copying some cells
from it. I kept getting a message

"There is a large amount of info in the clipboard, do you want to keep
it to be used by another program"

I always had to click "Yes" before the macro would proceed. Is there a
method to add to the .CLOSE command so that VBA knows to save the info
in the clipboard and doesn't have to ask me?

Lance