Macro Stops

R

Rudy Dunham

I am trying to run a macro but it stops because a question
pops up "There is a large amount of information on the
Clipboard. Do you want to be able to paste this
information into another program later?". Is there
someway to tell Excel to save it all of the time and
eliminate this question?

Thanks.
 
D

Dave Peterson

It happens when you're closing a workbook after a copy?

how about:
application.displayalerts = false
workbooks("yourwkbk.xls").close savechanges:=false
application.displayalerts = true

And if you just wanted the clipboard emptied:

application.cutcopymode = false
 
Top