This has been really helpful - thank you - and works well when one cell at a
time is being copied/pasted from other sheets. Is there a way of achieving
the same when a block of cells is copied?

"Harlan Grove" wrote:

"Harlan Grove" wrote...
....
This is where Excel is REALLY STUPID. Excel 2002, 2000 and 97 all allow
pasting ranges cut from other worksheets into unlocked ranges in
protected worksheets. Maybe this has been fixed in Excel 2003, but I
doubt it.
....

OK, still stupid, but not uncommon.

FWIW, Lotus 123R5 and 123R97 both allow moving cells into unlocked cells in
protected worksheets (both /WGPE and sealed workbooks).

OpenOffice Calc also allows this, but OOo Calc has fundamentally different
semantics. If C2 contains the formula =B2+1 and C3 contains the formula
=B3+1, and if I cut B3 and paste into B2, the formula in C2 remains =B2+1
and the formula in C3 changes to =B2+1.