Workbook.SheetFollowHyperlink Event

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Private Sub Workbook_SheetFollowHyperlink(ByVal Sh as Object, _
    ByVal Target As Hyperlink)
    UserForm1.ListBox1.AddItem Sh.Name & ":" & Target.Address
    UserForm1.Show
End Sub

See Also