How do I protect cells against only the "Delete" function?

[Kev Nurse]

Hi folks,

I have a shared worksheet full of textual data (names). I want the users to
be able to freely move the data around the sheet by simple dragging movement
or through cut and paste. However, deleting any data (even if immediate
re-entering elsewhere is intended) must not be allowed in any circumstance.

Is this possible? If so, how?

Thanks for any guidance

Kevin Nurse

 

[Dave Peterson]

See one suggestion at your first post.

Hi folks,

I have a shared worksheet full of textual data (names). I want the users to
be able to freely move the data around the sheet by simple dragging movement
or through cut and paste. However, deleting any data (even if immediate
re-entering elsewhere is intended) must not be allowed in any circumstance.

Is this possible? If so, how?

Thanks for any guidance

Kevin Nurse