ExcelHyperlink Properties |
The ExcelHyperlink type exposes the following members.
Name | Description | |
---|---|---|
Address |
The target address to which this hyperlink points.
The target address can be a URL (e.g. 'http://www.mysite.com' or 'maito://support@mysite.com'),
a file or folder in the file system (e.g. 'file://C:\MyFolder' or 'file://C:\MyFolder\MyFile.txt'
or file://\\MyServer\MyFolder)
or a range adress from the same worksheet or another worksheet (e.g. 'MySheet!A1' or 'A1:B2' ) function of the hyperlink type.
When the address is a range address, the name of the range cannot contain white spaces. You can define a named range if the target
worksheet name contains spaces.
| |
Name |
Gets the name of the hyperlink.
| |
Range |
Gets the range to which this hyperlink was attached.
| |
SubAddress |
Gets or sets the location inside the target document of the hyperlink.
| |
Text |
Gets or sets the text to be displayed for the hyperlink. If this property is not set the
target address will be used for the displayed text.
| |
ToolTip |
Gets or sets the tooltip text for this hyperlink.
| |
Type |
Gets or sets the hyperlink type.
|