Macro Stops

  • Thread starter Thread starter Rudy Dunham
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 Clipboard Question 6
macros 3
clipboard 1
Macro stops with "Large Amount of Data" Message 3
Get rid of Information message 3
Large amount of info on the clipboard 2
macro help - closing without saving & empty clipboard 3
Copy and Paste question 1

Back
Top