PROBLEM: Unable to set the Locked Property of the Range Class

[Pasadu]

After being guided here to set my worksheet as i wanted, additional modifications have caused me some problem. At first, i set my table in a way that Cell M4 can only be filled when cell L4 is filled. In the same way, cell M5 can only be filled when cell L5 is filled. The same was done for cells L6:M6 to L18:M18. If the L column cell is not filled, M column cell will be not selectable; But now, it does not work that way, maybe due to additional codes that i have added. Whenever i protect the sheet and fill in L4, when i press tab to go to M4, it tells me "Unable to set the Locked Property of the Range Class". Please help me. Thank You.

 

[Marc L]

An example without protecting the sheet and replacing the Worksheet_Change event :​

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 13 Then If IsEmpty(Target(1, 0)) Then Target(1, 0).Select
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​

 

[Pasadu]

Thank you Sir, sorry for the Late reply. I inserted the code and it is working perfectly.

 

[Marc L]

No problemo, thanks !​

​