Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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