Worksheet.Hyperlinks Property (Excel)
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