Hyperlinks Property
Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
For more information about returning an object from a collection, see Returning an Object from a Collection.
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