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

  • Thread starter Thread starter Kev Nurse
  • Start date Start date
K

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
 
See one suggestion at your first post.

Kev said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top