Macros and large clipboard error

  • Thread starter Thread starter Sarahds
  • Start date Start date
S

Sarahds

I have written a macro that copies info from 10 other workbooks an
pastes that into one workbook (consolidating, but including th
individual worksheets). In the macro, I close each workbook afte
doing the copying and pasting and click on the "No" when I get th
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 don
a manual click and then continues. How can I automate this?:confused:

Sara
 
before you get to that point

Application.CutCopyMode = False

clears the clipboard.

or

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