clipboard

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 ???
 
D

Dave Peterson

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