Export (0) Print
Expand All

Worksheet.Hyperlinks Property

Office 2007
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.”

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



Community Additions

ADD
Show:
© 2015 Microsoft