Expand Minimize

Worksheet.Hyperlinks Property (Excel)

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

expression .Hyperlinks

expression A variable that represents a Worksheet object.

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

Community Additions

ADD
Show:
© 2014 Microsoft