Or maybe the way is to not be able to "highlight" the specific cell,
therfore blocking it from being copied.

You could try that. Start by unlocking all cells. Select the small square
that intersects row/column headers, Format / Protection. Now lock A1:C3 and
protect the Sheet (Tools Protection).

In your VBE (alt-F11) find your project, expand and select the worksheet
module. In properties (F4) change EnableSelection to 1- xlUnlockedCells.

Plenty of ways to circumvent though, eg copy the Worksheet elsewhere.

Regards,
Peter T

"morins" wrote in
message ...

Does anyone have an idea on how to prevent a preselected cell in a
defined area from being copied (copy and paste) into another document
such as WORD?

For example: Ignore the content of cell B2 in the selected A1:C3
range.

Or maybe the way is to not be able to "highlight" the specific cell,
therfore blocking it from being copied.

Thanks for your help;

Stephane


--
morins
------------------------------------------------------------------------
morins's Profile:
http://www.excelforum.com/member.php...o&userid=26522
View this thread: http://www.excelforum.com/showthread...hreadid=541315