Workbook.SheetFollowHyperlink Event (Excel)
Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event.
Syntax
expression .SheetFollowHyperlink(Sh, Target)
expression An expression that returns a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
Required |
Object |
The Worksheet object that contains the hyperlink. |
Target |
Required |
Hyperlink |
The Hyperlink object that represents the destination of the hyperlink. |
Example
This example keeps a list, or history, of all the hyperlinks in the current workbook that have been clicked, plus the names of the worksheets that contain these hyperlinks.
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh as Object, _
ByVal Target As Hyperlink)
UserForm1.ListBox1.AddItem Sh.Name & ":" & Target.Address
UserForm1.Show
End Sub