Hyperlink Object Members

  • Article
Excel Developer Reference

Represents a hyperlink.

Methods

  Name Description
Bb242296.methods(en-us,office.12).gif AddToFavorites Adds a shortcut to the workbook or hyperlink to the Favorites folder.
Bb242296.methods(en-us,office.12).gif CreateNewDocument Creates a new document linked to the specified hyperlink.
Bb242296.methods(en-us,office.12).gif Delete Deletes the object.
Bb242296.methods(en-us,office.12).gif 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.

Properties

  Name Description
Bb242296.properties(en-us,office.12).gif Address Returns or sets a String value that represents the address of the target document.
Bb242296.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242296.properties(en-us,office.12).gif 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. Read/write String.
Bb242296.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb242296.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242296.properties(en-us,office.12).gif Range Returns a Range object that represents the range the specified hyperlink is attached to.
Bb242296.properties(en-us,office.12).gif ScreenTip Returns or sets the ScreenTip text for the specified hyperlink. Read/write String.
Bb242296.properties(en-us,office.12).gif Shape Returns a Shape object that represents the shape attached to the specified hyperlink.
Bb242296.properties(en-us,office.12).gif SubAddress Returns or sets the location within the document associated with the hyperlink. Read/write String.
Bb242296.properties(en-us,office.12).gif TextToDisplay Returns or sets the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink. Read/write String.
Bb242296.properties(en-us,office.12).gif Type Returns a Long value, containing a MsoHyperlinkType constant, that represents the location of the HTML frame.