Hyperlink Members (Excel)

Represents a hyperlink.

Methods

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.

Properties

Name

Description

Address

Returns or sets a String value that represents the address of the target document.

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.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

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.

Name

Returns a String value that represents the name of the object.

Parent

Returns the parent object for the specified object. Read-only.

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. Read/write String.

Shape

Returns a Shape object that represents the shape attached to the specified hyperlink.

SubAddress

Returns or sets the location within the document associated with the hyperlink. Read/write String.

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.

Type

Returns a Long value, containing a MsoHyperlinkType constant, that represents the location of the HTML frame.