Run macro on double click - several macros on one worksheet

Hi, I am fairly new at this so would appreciate any advice!

I have several macros written that open other workbooks. I have a "front page" worksheet with a list of these workbooks. I would like to be able to double click the name of the workbook and have it run the macro to open it.

I have gone into the code for this worksheet and have a private sub before double click. I then used "case" to state that if a certain cell was doubled clicked, then call the macro to open that workbook:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Select Case Target.AddressLocal(False, False)

    Case "G9"
        Call Blends
        Cancel = True

    Case "G11"
        Call Data
            Cancel = True

    Case "G13"
        Call Manufacture
        Cancel = True
    
    End Select
End Sub

My workbook open macros are working but the double click procedure isn't. Can anyone shed any light on why please? Or help me find a better way to do it?

Thank you in advance.

It's ok, I solved it!

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Row = 9 Then
        Call Blends
        ElseIf Target.Row = 11 Then
        Call Data
        End If
        
End Sub