Lock a cell based on another Cell in the entire sheet

Karun - Sep 6, 2017 at 08:48 AM - Latest reply: ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen
- Sep 6, 2017 at 05:06 PM
Hello,
I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please help.


See more 

Your reply

1 reply

ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Sep 6, 2017 at 05:06 PM
-1
Helpful
Take a look here, then take this method, and turn it into a macro:
https://support.microsoft.com/en-us/help/214081/xl-how-to-lock-individual-cells-in-a-worksheet

Have fun!
Respond to ac3mark