I have a lot of cells that are used by array formulas for calculation. I would like to prevent deletion of these cells. But the user should be able to enter data in these cells. There seems to be no option for this in excel's protection options. I also want to prevent insertion of cells between these cells. Can anyone please help me out?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Prevent deletion and insertion of cells without preventing any other operation
- Thread starter ditto
- Start date
HippoCampus
Board Regular
- Joined
- Sep 17, 2007
- Messages
- 195
Hi ditto
Could you make entry to the cells via a user form that unprotects the sheet, adds the data and re-protects the sheet. This way it would stop deletion of the cells and insertion of rows because the WS would be protected.
Could you make entry to the cells via a user form that unprotects the sheet, adds the data and re-protects the sheet. This way it would stop deletion of the cells and insertion of rows because the WS would be protected.
Upvote
0
HippoCampus
Board Regular
- Joined
- Sep 17, 2007
- Messages
- 195
Hi Ditto
Sorry but you did not mention copy and paste in your original mail, so I am afraid that I can't think of a solution.
Sorry but you did not mention copy and paste in your original mail, so I am afraid that I can't think of a solution.
Upvote
0
