ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I protect cells against only the "Delete" function? (https://www.excelbanter.com/excel-discussion-misc-queries/13508-how-do-i-protect-cells-against-only-%22delete%22-function.html)

Kev Nurse

How do I protect cells against only the "Delete" function?
 
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.

Kev Nurse wrote:

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


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com