VBA Hyperlink trigger macro

[APML]

Hi All, the following VBA is meant to trigger macros if the hyperlink at B4 or D4 is activated, however D4 doesn't trigger its macro,
All help greatly appreciated

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)



If Target.Range.Address = "$B$4" Then
Call NewRow

ElseIf Target.Range.Address = "$D$4" Then
Call DeleteRow

End If

End Sub

 

[chuggins143]

Might start with putting a debug.print "some name" after each then statement to see if it's triggering for each condition...

 

[frabulator]

The following code works for me.

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)

    If Target.Range.Address = "$B$4" Then
        MsgBox ("Clicked B4")
    
    ElseIf Target.Range.Address = "$D$4" Then
        MsgBox ("Clicked D4")
    
    End If

End Sub

You did put this code in the workbook section of the VBA editor instead of its own module, right?