I have a file from which I have done a copy/paste for a fair amount
of data. I have a macro to do this, and wish to close the window
totally. However when I use:

ActiveWorkbook.Close

I get a message asking whether I want to save the data on the
clipboard. I have looked in "help" for options to supress this
message, but cannot find them.Can someone give me the answer please.
Question is: How do I set the macro to avoid this message when
closing!!

Thanks in advance

John Baker