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

[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

 

[Kevin]

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

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

 

[Dan E]

Kevin - interesting way to do this, but not an option for me. Thanks
anyway.

dan

 

[Ken Wright]

See your other post for another possible approach.

 

[Dan E]

Ken - see my reply in my previous post.

Dan

See your other post for another possible approach.