Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "E5" Then
If Target.Value = "x" Then sperre 1
End If
End Sub
Sub Schaltfläche1_Klicken()
sperre 0
End Sub
Sub sperre(ja_nein As Boolean)
Range("F5:J5").Locked = ja_nein
End Sub