hi.. i'm dealing with a question here...
I have a worksheet where i have 2 collumns, collumn D and E.
The data starts in D10 and goes down to D1000. On D i can have all king of data but in collumn E all i can have is "A" ou nothing "". So what i need is if in cell E12="A" then D12 will become unlocked. If E12 is empty "", then D12 should remain locked. And this for all range of D10:D1000 and E10:E1000.
The password for the sheet is: "nocoments"
I came across with some code after researching in google, but its only for one cell and not a range... for example:
This code is for one cell only, but i need something similar for the entire range.. .if E10 is A then D10 is unlocked, if E11 is A then D11 is unlocked... and so on....
Please can someone help?
Thank you.
Bookmarks