Hyperlink Object [Excel 2003 VBA Language Reference]
Multiple objects.gif) Hyperlink.gif) 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.
Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow
Properties | Address Property | Application Property | Creator Property | EmailSubject Property | Name Property | Parent Property | Range Property | ScreenTip Property | Shape Property | SubAddress Property | TextToDisplay Property | Type Property
Methods | AddToFavorites Method | CreateNewDocument Method | Delete Method | Follow Method
Parent Objects | Hyperlinks Collection | Shape Object
Child Objects | Range Object | Shape Object