Macros and large clipboard error

I have written a macro that copies info from 10 other workbooks and pastes that into one workbook (consolidating, but including the individual worksheets). In the macro, I close each workbook after doing the copying and pasting and click on the "No" when I get the question "do I want to keep the large amount in the clipboard". However, when I run the macro, it stops at that point until I have done a manual click and then continues. How can I automate this?

Sarah

before you get to that point

Application.CutCopyMode = False

clears the clipboard.

or

Application.Displayalerts = False
' code the closes the workbook
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Sarahds" <Sarahds.2bw4n7_1154484912.0846@excelforum-nospam.com> wrote in
message news:Sarahds.2bw4n7_1154484912.0846@excelforum-nospam.com...
>
> I have written a macro that copies info from 10 other workbooks and
> pastes that into one workbook (consolidating, but including the
> individual worksheets). In the macro, I close each workbook after
> doing the copying and pasting and click on the "No" when I get the
> question "do I want to keep the large amount in the clipboard".
> However, when I run the macro, it stops at that point until I have done
> a manual click and then continues. How can I automate this?
>
> Sarah
>
>
> --
> Sarahds
> ------------------------------------------------------------------------
> Sarahds's Profile:
> http://www.excelforum.com/member.php...o&userid=37005
> View this thread: http://www.excelforum.com/showthread...hreadid=567292
>