Hi All,

I have a problem / question.

Sheet1 in my workbook has this code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Target.Range.Address = Range("C27").Address Then Legen
End Sub
"Legen" is the name of the macro, and if the hyperlink is clicked, it works fine.

In Sheet2 i have this code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Target.Range.Address = Range("E33").Address Then CleanSheet

End Sub
"CleanSheet" is the name of the macro, and if i click the hyperlink it does nothing.

I don't understand because it's litterally the same as in sheet1, only difference then the location of the hyperlink and the name of the macro....

Does anyone have tips, advice?


Thanks in advance!

Regards,
Crispy