Skip to main content

Hyperlink object

Table of contents
  1. Remarks
  2. Example

Represents a hyperlink.

Remarks

The Hyperlink object is a member of the Hyperlinks collection.

Example

Use the Hyperlink property of the Shape object to return the hyperlink for a shape (a shape can have only one hyperlink). The following example activates the hyperlink for shape one.

Worksheets(1).Shapes(1).Hyperlink.Follow NewWindow:=True

A range or worksheet can have more than one hyperlink. Use Hyperlinks (index), where index is the hyperlink number, to return a single Hyperlink object. The following example activates hyperlink two in the range A1:B2.

Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>