Unlock cell/s dependant upon entry in another cell

[caspollux23]

I've never dealt with vba before and I'm not even sure if that's correct. I wish to lock a worksheet with two cells left unlocked, when an entry is made in one or other of these two cells I need other cells to become unlocked. I have searched on the web but can only find info about locking worksheets.

[shg]

Here's an example.

Open a new workbook, select A1:A10, and unlock the cells.

Then protect the workbook, allowing selection of unlocked cells only.

Then right-click the Sheet tab, select View Code, and paste this in the window that opens:

Private Sub Worksheet_Change(ByVal Target As Range)
    Me.Protect Password:="", UserInterfaceOnly:=True
    With Target
        If .Count = 1 And .Column < Me.Columns.Count Then .Offset(, 1).Locked = False
    End With
End Sub

Close all that and go back to Excel.

You can only select A1:A10. Entering something in one of those cells will unlock the cell to the right; enter something in that cell, and it will unlock the next.

If you've never used VBA, this might not be the easiest place to start.

[caspollux23]

shg - thank you for your reply, I have started looking at tutorials to learn about vba but in the meantime the cells I wish to be open are G16 and O16, if a "Y" is entered in G16 then I need G27, G31, G33 and G36 to unlock, each one unlocking the next if necessary. for O16 I need O21, O23, O27, O31, O33 and O36 to unlock. Is this possible?