Prevent Copying Data
 

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

Prevent Copying Data
 

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

Prevent Copying Data
 

Have you tried using cell locking and protection to stop users from
destroying your conditional formatting, this would still allow then the
convenience of being able to paste data into the cells. There's a short
tutorial in the Excel section on my website that might help.

HTH

Neil
www.nwarwick.co.uk

"Chrisp" wrote:


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