DoubleClickEvent.xlsxHello all

I've attached a file to help demonstrate what i'm tryng to achieve, and as usual any help is gratefully received and appreciated.

In the attached file are 10 options available to five different users. So far I have some VBA code set up so that any cell double clicked in the range C3 to G12 will toglle between 'Yes' and 'No' values. All well and good so far...

What I want to be able to do now though is the following - if Option1 is selected 'Yes' for any given user (so in this example let's use User2, in column D), that this change will cause two things to happen:

1) it will change all other options for that particular user (ie: from Option2 to Option10) to a 'No' value.
2) it will then stop the double click event working if you then try to change one of those options to a 'Yes' while option 1 is still set at 'Yes'.

For reference this is the VBA I'm using so far just to deal with the Yes/No toggle:

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
If Not Intersect(Target, Range("l30:cd48")) Is Nothing Then
Cancel = True

With Target.Cells(1)
    If .Value = "No" Then
       .Value = "Yes"
    Else
       .Value = "No"
    End If

End With

End If
Can anyone help please??

Thanks
Kenny