You have a good point, disabling copy/paste may not be ideal.

What about this:
Can I use an isolated clipboard that's only available to Excel and Word and
it's not affected by what users copy in other applications?

"Ronald Dodge" wrote in message
...
This would be really tough to disable as the copying and pasting is done
not just to MS Office programs, but for all programs on the system. Also,
if your program is ran in the background and the user is working on other
items, would you really want this disabled to the point that the user
can't do any sort of copying and pasting with other apps? I could just
see how other users would view this, so be very careful about this.

The more idea solution, which I have had to use within my production
reporting system, though also has some draw backs similar to your
situation, first avoid using the "Copy" method as "Reasonably" possible,
but rather take values directly from one cell to another cell, which works
okay for smaller ranges, but may be a time lagger for larger ranges. Once
this is done, then for those larger ranges, use the DestinationRange
argument within the Copy method of the SourceRange object. Right after
that takes place, let the CutCopyMode property on the Application object
to "False".

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Richard" wrote in message
...
How can I stop users from using Copy/Paste in any application while my
macro is running?

Or, can I use an isolated clipboard that's only available to Excel and
Word and it's not affected by what users copy in other applications?

Regards,
Richard