Password Protect a cell from deleting

Hey guys,

I am stuck with this problem.

I need to password protect Range "A1:A3000" with a vba code.

So if anyone tries to delete the range then they are promted to type the password then only they can delete the cell in the range.

Is this possible?

Maybe use Allow Users to Edit Ranges

I cannot make it read only because i have 3 other people who use the same file.
They use it to make invoices.

I just want to ensure that they do not delete the contents of the cell.
So i want to password protect it

did you read post#3 ?

see this one

sheet pass: abc
range pass: 123456

sandy666, how is that file protected? I deleted everything and saved it. All contents are gone.

with known pass you can do everything
if user don't know pass he can't delete or change
btw. Excel security level is 0

But it didn't ask for a password. I don't really understand this.

do you have something like this?

passforrange.jpg

if yes, unlock whole sheet, select range, lock cells, set pass for this range, then set pass for worksheet

if not - forget it

I see. but I can delete the contents.

maybe you doing something wrong or Ex2007 doesn't support this feature well

but, like I said above, security level is 0 because I can remove pass in 5 secs

ok. thanks.

You are welcome