By default all cells in a worksheet are locked so when u activate the
protection (ToolsProtectionProtect sheet..) with the "Protect
worksheet and contents of locked cells" flagged all cells remain
locked/protected.

1st u may have to unlock that particular cell that u r trying to paste
into by removing the flag from FormatCellsProtection Locked checkbox,
then reactivate the Protect sheet functionality.

Only have "Select unlocked cells" & "Format columns" flagged. The
latter to allow u to adjust the column width just in case the copied
text is greater than the column width.

Hope this solves ur problem.

Cheers.


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=379199