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.
 
Back
Top