Hyperlinks Collection
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Hyperlinks Collection [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
Hyperlinks
Hyperlink
Multiple objects

Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.

Using the Hyperlinks Collection

Use the Hyperlinks property to return the Hyperlinks collection. The following example checks the hyperlinks on worksheet one for a link that contains the word Microsoft.

For Each h in Worksheets(1).Hyperlinks
    If Instr(h.Name, "Microsoft") <> 0 Then h.Follow
Next
		

Use the Add method to create a hyperlink and add it to the Hyperlinks collection. The following example creates a new hyperlink for cell E5.

With Worksheets(1)
    .Hyperlinks.Add .Range("E5"), "http://example.microsoft.com"
End With
		


Parent Objects | Chart | Range | Worksheet

Child Objects | Range | Shape


Show:
© 2016 Microsoft