Report

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
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.


Helpful
-1
plus moins
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!
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!