HotXLS Docs

Hyperlinks property

Returns a IXLSHyperlinks collection that represents the hyperlinks for the specified range. Read only IXLSHyperlinks.

Syntax

property Hyperlinks: IXLSHyperlinks;

Example

This example changes ScreenTip of hyperlink one on the cell A5.

Workbook.Worksheets[1].Range['A5', 'A5'].Hyperlinks[1].ScreenTip := 'New ScreenTip';
This example deletes hyperlinks from range A1:F5.

Workbook.Worksheets[1].Range['A1', 'F5'].Hyperlinks.Delete;