Lock a cell based on another Cell in the entire sheet

Ask a question Karun - Last answered on Sep 6, 2017 at 05:06 PM by ac3mark
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.

plus moins
Take a look here, then take this method, and turn it into a macro:

Have fun!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!