John

I generally copy cells when I need more than just the value (e.g.
formatting, data validation). If I just need the value, I set the Value
property of the destination cell equal to the Value property of the source
cell. This avoids the clipboard and will probably be faster.

Five minutes of copying is quite a bit, unless you're running a 486 machine.
I would concentrate on getting that five minutes down to under 30 seconds.
If you describe what you're doing, maybe someone can help you do that.

I don't know of any way to lock the clipboard without locking out the whole
computer.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


John Austin wrote:
I have a VB app that creates an instance of Excel, and then
intensively gets Excel to copy and paste data between worksheets. The
problem that I have is that whilst this is going on (for about 5
minutes), if the user copies data in another application, then that
data is pasted into Excel instead of the data that was intended.

How can Excel 'lock' the clipboard between the Copy and Paste
commands so as to ensure that this does not happen?

John Austin