How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting th

D

Dan E

I want to prevent users from MOVING, CUTTING or DELETING data cells (which
would cause any reference to that cell to give an error), but allow them to
clear the contents of the cell and enter new values (in other words, be able
to edit the cell). Any suggestions VERY welcome.

TIA,

Dan
 
K

Kevin

Dan said:
I want to prevent users from MOVING, CUTTING or DELETING data cells (which
would cause any reference to that cell to give an error), but allow them to
clear the contents of the cell and enter new values (in other words, be able
to edit the cell). Any suggestions VERY welcome.

TIA,
Dan
Click to expand...

I posted a similar question recently ...
Max's solution has worked perfectly for me. See this thread :

http://groups-beta.google.com/group...in+max++insert+delete&rnum=1#19148b91e9862df5
 
Top