This documentation is archived and is not being maintained.

Hyperlink Object [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
Multiple objects

Represents a hyperlink. The Hyperlink object is a member of the Hyperlinks collection.

Using the Hyperlink Object

Use the Hyperlink property 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 folllowing example activates hyperlink two in the range A1:B2.


Child Objects | Range Object | Shape Object