This documentation is archived and is not being maintained.

Hyperlink Members 

Represents a hyperlink.

The following tables list the members exposed by the Hyperlink type.

  Name Description
Address Returns or sets the address of the target document.
Application Returns an Application object that represents the Microsoft Excel application.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
EmailSubject Returns or sets the text string of the specified hyperlink’s e-mail subject line. The subject line is appended to the hyperlink’s address.
Name Returns the name of the object. Read-only String.
Parent Returns the parent object for the specified object.
Range Returns a Range object that represents the range the specified hyperlink is attached to.
ScreenTip Returns or sets the ScreenTip text for the specified hyperlink.
Shape Returns a Shape object that represents the shape attached to the specified comment, diagram node, or hyperlink.
SubAddress Returns or sets the location within the document associated with the hyperlink.
TextToDisplay Returns or sets the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink.
Type Returns the location of the HTML frame.

  Name Description
AddToFavorites Adds a shortcut to the workbook or hyperlink to the Favorites folder.
CreateNewDocument Creates a new document linked to the specified hyperlink.
Delete Deletes the object.
Follow Displays a cached document if it’s already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application.