Hi,

I have a hyperlink that calls a macro.
But now i want to use more hyperlinks, each to call his own macro.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Target.Range.Address = Range("I11").Address Then AddRow
End Sub

Sub AddRow()
    Range("D12").EntireRow.Select
    Selection.Copy
    Selection.Insert Shift:=xlUp
    
    Range("E12").Value = ""
       
End Sub
This is one hyperlink, it's in cell I11.

I now also have a hyperlink in Cell C10.
When clicked on this hyperlink it should Unhide row 11 and 12.

But how do i start scripting?

Thanks so much for the help!!

regards,
Crispy85