Lock a cell based on adjacent cell value

[bsutton19]

What code can I use to lock A2 only if A3=1?

 

[mumps]

Unlock cell A2. Protect the sheet and run this macro:

Sub UnlockCell()
    ActiveSheet.Unprotect
    If Range("A3") = "1" Then
        Range("A2").Locked = True
    End If
    ActiveSheet.Protect
End Sub

 

[bsutton19]

I need help locking cells in a range that is copied from another sheet based on user input. I am able to change the color with conditional formatting, but can not figure out how to lock out cells that are part pf a header. A simplified example is:

Cells A1:A100 are mostly input cells. However, if a corresponding cell in B1:B100 = 1, the matching "A" cell needs to be locked. What code can I use to make this happen?

 

[mumps]

What works on sample data very often doesn't work on the actual data. Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, ranges and worksheets particularly what you mean by

locking cells in a range that is copied from another sheet based on user input.

If the workbook contains confidential information, you could replace it with generic data.