clipboard

  • Thread starter Thread starter Zygan
  • Start date Start date
Z

Zygan

when i set up a macro to copy a range from BOOK1 to BOOK2, a popup comes
up and says there is a large amount of information on the clipboard. Do
you want to be able to be paste this information into a another program
later ?
click yes to save
click no to not save


how can i automate the answer or simply prevent it from showing.


Help please ???
 
You sure you're not getting it when you're closing the "from" workbook?

If you are getting it when you're closing the workbook, try adding:

Application.cutcopymode = false

in your copy|paste macro after you are done pasting.
 

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
Paste Special in Excel 2003 6
VBA - Testing for Book1, Book2 etc. 2
Excel 2003 - VBA - Eliminate Clipboard Message 2
clipboard 1
can't paste from clipboard in my macro 1
Large amount of info on the clipboard 2

Back
Top