Previous Topic Next Topic

Lock a cell based on another Cell in the entire sheet

Closed
Karun - Sep 6, 2017 at 08:48 AM
 Blocked Profile - 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.


1 response

Answer 1 / 1
Blocked Profile
Sep 6, 2017 at 05:06 PM
Take a look here, then take this method, and turn it into a macro:
https://support.microsoft.com/en-gb/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a?ui=en-us&rs=en-gb&ad=gb

Have fun!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Name Values
brendanconlin -
TrowaD -

1 response