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


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=560976

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.



Zygan wrote:

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

--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=560976

--

Dave Peterson