Worksheet.Hyperlinks Property

Returns a Hyperlinks collection that represents the hyperlinks for the worksheet.

Syntax

expression.Hyperlinks

expression   A variable that represents a Worksheet object.

Example

This example checks to see whether any of the hyperlinks on worksheet one contain the word “Microsoft.”

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

See Also

• Worksheet Object
• Worksheet Object Members