Excel.Hyperlink.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Hyperlink object (Excel)	vbaxl10.chm535072	vbaxl10.chm535072	Excel.Hyperlink	8bdd2c2f-e6eb-a2f2-78c8-b597aa80ec05	03/30/2019	medium

Hyperlink object (Excel)

Represents a hyperlink.

Remarks

The Hyperlink object is a member of the Hyperlinks collection.

Example

Use the Hyperlink property of the Shape object to return the hyperlink for a shape (a shape can have only one hyperlink). The following example activates the hyperlink for shape one.

Worksheets(1).Shapes(1).Hyperlink.Follow NewWindow:=True

A range or worksheet can have more than one hyperlink. Use Hyperlinks (index), where index is the hyperlink number, to return a single Hyperlink object. The following example activates hyperlink two in the range A1:B2.

Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow

Methods

• AddToFavorites
• CreateNewDocument
• Delete
• Follow

Properties

• Address
• Application
• Creator
• EmailSubject
• Name
• Parent
• Range
• ScreenTip
• Shape
• SubAddress
• TextToDisplay
• Type

See also

• Excel Object Model Reference

[!includeSupport and feedback]