FollowHyperlink

Occurs when a hyperlink is clicked.

Property Description
Address For a hyperlink that represents a web address, email, or existing file, the Address is the address of the hyperlink.
EmailSubject For a hyperlink that represents an email, the subject of the email.
RangeAddress The address of the cell or range that the hyperlink is attached to.
SubAddress For a hyperlink that represents an existing file or a range within the same workbook, the SubAddress is the bookmark in the linked file or the address within the same workbook, such as "Sheet1!A1".