Click to Rate and Give Feedback
MSDN
MSDN Library
Visual Studio 2008
Visual Studio
Reference
 Hyperlinks Property (2007 System)

  Switch on low bandwidth view
This page is specific to
Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:
Visual Studio Tools for Office API Reference
Worksheet..::.Hyperlinks Property (2007 System)

Gets a Microsoft.Office.Interop.Excel..::.Hyperlinks collection that represents the hyperlinks for the range or worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Visual Basic (Declaration)
<BrowsableAttribute(False)> _
Public ReadOnly Property Hyperlinks As Hyperlinks
Visual Basic (Usage)
Dim instance As Worksheet
Dim value As Hyperlinks

value = instance.Hyperlinks
C#
[BrowsableAttribute(false)]
public Hyperlinks Hyperlinks { get; }

Property Value

Type: Microsoft.Office.Interop.Excel..::.Hyperlinks
A Microsoft.Office.Interop.Excel..::.Hyperlinks collection that represents the hyperlinks for the range or worksheet.

The following code example uses the Hyperlinks property to add a hyperlink to the Microsoft.Office.Interop.Excel..::.Hyperlinks collection of the worksheet.

This example is for a document-level customization.

Visual Basic
Private Sub AddHyperLink()
    Dim link As Excel.Hyperlink = _
        CType(Me.Hyperlinks.Add(Me.Range("A1"), _
        "http://www.microsoft.com", ScreenTip:="Microsoft", _
        TextToDisplay:="Microsoft's Website."), Excel.Hyperlink)
End Sub

C#
private void AddHyperLink()
{
    Excel.Hyperlink link = (Excel.Hyperlink)this.Hyperlinks.Add(
        this.Range["A1", missing], "http://www.microsoft.com",
        missing, "Microsoft", "Microsoft's Website.");
}

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker