共用方式為


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

請參閱

概念

Workbook Object

Workbook Object Members