Hi Ivan,
See Chip Pearson's Clipboard page at:
http://www.cpearson.com/excel/clipboar.htm
See particularly the section at the foot of the page entitled:
'Clearing the Clipboard'
---
Regards,
Norman
"Ivan" wrote in message
...
Hi,
I am writing a macro program which copies the contents whole sheet1 of
workbook1 and paste it to sheet1 to workbook2. After that, the program
closes
workbook1. But I always got a prompt and saying that I have a large amount
of
information in Clipboard and it askes if I want to be able to paste into
another program later. Actually I don't want this prompt and closes
workbook1
directly. Anyone knows how to bypass this programatically?
Thanks!
Ivan