Track when a link is clicked

[starfruitpancakes]

Hi all!

I was wondering if there is a function to be able to track when the last time a hyperlink was clicked and display the date in a new cell??

Much appreciated.. Thank you!

[Richard Buttrey]

Hi, and welcome to the forum.

In this sheet event

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    Range("A1") = Date

End Sub