I have so far made this macro and it works when i manually change a value in cell A43. The thing i want to know is if how i can modificate this code
in a way that this code runs even if A43 changes value due to a fomula and not manually.

Private Sub Worksheet_change(ByVal Target As Range)
If [A43] = 1 Then
ActiveSheet.Unprotect
[B30:C30].Locked = False
ActiveSheet.Protect
End If
If [A43] = 0 Then
ActiveSheet.Unprotect
[B30:C30].Locked = True
ActiveSheet.Protect
End If
End Sub