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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.