clipboard

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

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



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