Hello,

I'm trying to make a spreadsheet that when you enter data into a cell it can only be deleted with a password, so using some form of protection that activates once the cell is occupied. Its not just for a few cells, but the entire sheet.

Anyone have any ideas please?

right click the sheet title at the bottom and select Protect you can then choose the protection level and set a password

Yeah this.

_________________
The above post, unless specifically stated to the contrary, should not be taken seriously. If the above post has offended you in any way, please fill in this form and return it to your nearest moderator.

Thanks for the answers guys, but I should have been clearer. When user A inputs something into a cell the cell will lock, meaning user A can't change that cell, but can enter data into all other empty cells. The only way to unlock it is for user B to input a password to the unlock sheet option. This means that users can input data, but not delete it.

I found this on google:



This works fine, but I don't know how to add the password in the code. At the moment If I lock the sheet with a password, then fill a cell it asks for a password. But the user who is entering the information wont know the password.

Anyone know how I would format that?

No idea if you can do that. Have you considered using a form for the data input?

_________________
This is the death of intelligence

The method I mentioned before actually works. Almost.

Basically, all cells are formatted so they aren't locked (right click on them, formatting, un-check the box. Something like that). Then you lock the whole sheet (but the cells aren't locked yet, see), and what the macro I quoted before does is when ever a cell isn't empty it will check this box automatically for you, meaning to have to unlock the whole sheet to edit data. (It's a macro that's always on, not one you activate as and when you need it)

But this is no good without a password to stop people unlocking the sheet and editing the data. But if I just add a password to the sheet it needs it halfway through the macro, so only the person who knows the password can enter data, which is against the point. So I need to enter the password in the code. Somewhere. I'm not sure where.

What I might do I record a macro of me running the macro and entering the password and finding what code this makes, but I can't do this until tomorrow.

God damn, I hate only knowing enough to know I don't know what I'm doing.

Turns out all I need to do was add ("password") after .unprotect or .protect

Damn, at least it works now.