Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SmartTags Property (2007 System)
Collapse the table of content
Expand the table of content

Worksheet.SmartTags Property (2007 System)

Gets a SmartTags object representing the collection of smart tags for the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

[BrowsableAttribute(false)]
public SmartTags SmartTags { get; }

Property Value

Type: SmartTags
A SmartTags object representing the collection of smart tags for the worksheet.

The following code example adds a smart tag to a NamedRange control and then uses the SmartTags property to display the number of smart tags on the current worksheet.

This example is for a document-level customization.

private void DisplaySmartTags()
{
    Microsoft.Office.Tools.Excel.NamedRange NamedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", missing],
        "NamedRange1");

    Globals.ThisWorkbook.SmartTagOptions.EmbedSmartTags = true;
    Globals.ThisWorkbook.Application.SmartTagRecognizers.Recognize = true;

    NamedRange1.Formula = "MSFT";
    Excel.SmartTag SmartTag1 =
        NamedRange1.SmartTags.Add(
        "urn:schemas-microsoft-com:smarttags#StockTickerSymbol");

    MessageBox.Show("There are " + this.SmartTags.Count.ToString() +
        " smart tags in this document.");
}

Community Additions

ADD
Show:
© 2015 Microsoft