Ivan:
try,
Use Application.CutCopyMode = False
example,
****.copy
.................
****.Past
Application.CutCopyMode = False
--
天行健,君*以自強不息
地勢坤,君*以厚德載物
http://www.vba.com.tw/plog/
"Ivan" wrote:
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