Input information in cell but once input no one can delete?

You would have to use a macro, and all the macro would do is the equivalent of Tools>Protection.

For instance:

You could leave the cells that can be changed unlocked and lock the rest of the cells and then protect the sheet. Then use some worksheet change event code to unprotect the sheet, lock the cell that was just changed, then protect the sheet. It may look something like this


Note that this is untested on my part and you will have to make sure that the wrong cells are not already locked, you can also add password like so....

Sheets("Sheet1).Protect("YourPasswordHere")
of course then you will need the password in the unprotect line in the same fashion.

Hope this is helpful!

Thanks for the help, this works perfect for one cell, How can i do this for each cell? in that after the first cell is protected i click into another cell which then gets unprotected i then input my data and this then gets reprotected.

Regards

The code will work for every cell on the sheet. The Target variable will refer to whatever cell(s) have been changed. It is dynamic.

If you want to be able to enter into any cell to begin with, you should make sure all of the cells are unlocked. That way when the sheet is protected if you make a change, only the cells you changed will be locked and the others should still be available to edit.

So, do this:
- Unprotect the sheet (if needed)
- Ctrl+A (selects all cells on the sheet)
- Format->Cells->Protection tab
- Uncheck the box next to "Locked."
- Click OK

All cells on that sheet should now be unprotected. When you edit a cell, the macro should kick in and then lock only those cells you changed, and then protect the sheet so that those cells can no longer be changed.

Edit: There is a difference in the code I posted and the code Brian posted, though. My code will work only on the active sheet (the one you make the changes on). Brian's code will only unprotect a sheet named "Sheet1"--it will not matter whether that is the active sheet or not.

Thanks Kirsty that works a treat! You certainly are an MVP!!!

Edit: There is a difference in the code I posted and the code Brian posted, though. My code will work only on the active sheet (the one you make the changes on). Brian's code will only unprotect a sheet named "Sheet1"--it will not matter whether that is the active sheet or not.

Click to expand...

That is a very good point... I had thought I mentioned that in the post but I obviously did not.