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