How to Lock entire Row if the cell value in G=0 using VBA.

[Sanoj]

How Lock entire Row if the cell value in “N” column =0, else respective row for which value in "N" column is not equal to 0 should be open to edit. Using VBA even cut paste should not work for the locked cells.

Please help if it’s possible. The file is attached.

Book2.xlsx

[Sanoj]

Any help.....?????? Its little urgent......

[Fotis1991]

Hi

You want, only VBA? I think that you can do it, using Custom Validation.

[Sanoj]

But I tried using Custom validation option but by that we can still amend by copy paste function or even we can delete the value in the locked cells, I thought VBA is better option.

Please let me know if it’s possible.

[Fotis1991]

Using Custom Validation, JUST lock the range and don't allow to the user to type something if you don;t want to do this.

User can delete the values and also can do copy-paste...

[Sanoj]

Hi Thanks for your reply but I am not sure how to do it. I dont know how to lock the cells using custom validation.
Can you please help me by showing it in the attached sheet... Book2.xlsx

[Fotis1991]

Hi

Take a look to the sample.

[Sanoj]

Thanks for your help but I am able to type in all the cells... Book2(1).xls

[Fotis1991]

...I had lock, ONLY column A.

Look now...

[Sanoj]

Yes we cannot enter data but we can paste and delete data from the locked cell which i want to prevent.

[Fotis1991]

...User can delete the values and also can do copy-paste...

This is a piece from my answer in Post#5.

And now you tell me again the same.

Yes we cannot enter data but we can paste and delete data from the locked cell which i want to preven

t.

I told you, Just don't allow to type anything. Just this!!

[Sanoj]

Yes right, Thats the reason I was looking for a VBA Coding...

[Sanoj]

Any help with VBA Coding???

[Sanoj]

Any help??????