Syntax

expression.SheetFollowHyperlink(Sh, Target)

expression An expression that returns a Workbook object.

Parameters

Name Required/Optional Data Type Description
Sh Required Object The object that contains the hyperlink.
Target Required Hyperlink The 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: