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

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

--
Dan E
webbie(removethis)@preferredcountry.com

Dan E (removethis) wrote:
> 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/...148b91e9862df5

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

dan
"Kevin" <[email protected]> wrote in message
news:[email protected]...
> Dan E (removethis) wrote:
>> 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/...148b91e9862df5
>

See your other post for another possible approach.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
news:[email protected]...
> 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
>
> --
> Dan E
> webbie(removethis)@preferredcountry.com
>
>

Ken - see my reply in my previous post.

Dan
"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> See your other post for another possible approach.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
> news:[email protected]...
>> 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
>>
>> --
>> Dan E
>> webbie(removethis)@preferredcountry.com
>>
>>
>
>