Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Hyperlink Object (Excel)

Represents a hyperlink.

The Hyperlink object is a member of the Hyperlinks collection.

Use the Hyperlink property 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 folllowing example activates hyperlink two in the range A1:B2.

Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.