How about an event macro tied to the Worksheet_SelectionChange event that
clears the clipboard. Probably not foolproof, but may help.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Chrisp" wrote in
message ...
Is there a way to prevent users from copying data within a worksheet
while still leaving cells open for entry. My problem is they are
copying data into cells that when the data is pasted, it wipes out the
conditional formatting. Any ideas?
--
Chrisp
------------------------------------------------------------------------
Chrisp's Profile:
http://www.excelforum.com/member.php...fo&userid=6365
View this thread: http://www.excelforum.com/showthread...hreadid=526229