Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2005
Visual Studio
Visual Studio Tools for Office
Reference
Microsoft.Office.Tools.Excel
Workbook Class
Workbook Properties
_CodeName Property
_ReadOnlyRecommended Property
AcceptLabelsInFormulas Property
ActiveChart Property
ActiveSheet Property
Application Property
Author Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
BuiltinDocumentProperties Property
CalculationVersion Property
ChangeHistoryDuration Property
Charts Property
CodeName Property
Colors Property
CommandBars Property
Comments Property
ConflictResolution Property
Container Property
CreateBackup Property
Creator Property
CustomDocumentProperties Property
CustomViews Property
Date1904 Property
DialogSheets Property
DisplayDrawingObjects Property
DisplayInkComments Property
DocumentLibraryVersions Property
EnableAutoRecover Property
EnvelopeVisible Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
FileFormat Property
FullName Property
FullNameURLEncoded Property
HasMailer Property
HasPassword Property
HasRoutingSlip Property
HighlightChangesOnScreen Property
HTMLProject Property
InactiveListBorderVisible Property
InnerObject Property
IsAddin Property
IsInplace Property
KeepChangeHistory Property
Keywords Property
ListChangesOnNewSheet Property
Mailer Property
Modules Property
MultiUserEditing Property
Name Property
Names Property
OnSave Property
OnSheetActivate Property
OnSheetDeactivate Property
Parent Property
Password Property
PasswordEncryptionAlgorithm Property
PasswordEncryptionFileProperties Property
PasswordEncryptionKeyLength Property
PasswordEncryptionProvider Property
Path Property
Permission Property
PersonalViewListSettings Property
PersonalViewPrintSettings Property
PrecisionAsDisplayed Property
ProtectStructure Property
ProtectWindows Property
PublishObjects Property
ReadOnly Property
ReadOnlyRecommended Property
RemovePersonalInformation Property
RevisionNumber Property
Routed Property
RoutingSlip Property
Saved Property
SaveLinkValues Property
SharedWorkspace Property
Sheets Property
ShowConflictHistory Property
ShowPivotTableFieldList Property
SmartDocument Property
SmartTagOptions Property
Styles Property
Subject Property
Sync Property
Tag Property
TemplateRemoveExtData Property
Title Property
UpdateLinks Property
UpdateRemoteReferences Property
UserControl Property
UserStatus Property
VBASigned Property
VBProject Property
VstoSmartTags Property
WebOptions Property
Windows Property
Worksheets Property
WritePassword Property
WriteReserved Property
WriteReservedBy Property
XmlMaps Property
XmlNamespaces Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Workbook.VstoSmartTags Property

Visual Studio 2005

Gets the Microsoft.Office.Tools.SmartTagCollection associated with the workbook.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

C#
VB
Copy 
public SmartTagCollection VstoSmartTags { get; }

Property Value

The Microsoft.Office.Tools.SmartTagCollection associated with the workbook.

The following code example creates a smart tag that sets the font color of a cell to blue when the term "blue" is recognized. The example adds the smart tag to the workbook by using the VstoSmartTags property.

C#
VB
Copy 
private void AddSmartTag()
{
    Microsoft.Office.Tools.Excel.SmartTag colorTag = 
        new Microsoft.Office.Tools.Excel.SmartTag(
        "www.contoso.com/Demo#DemoSmartTag", "Demo Smart Tag");

    Microsoft.Office.Tools.Excel.Action colorText =
        new Microsoft.Office.Tools.Excel.Action("Color text blue");
    colorText.Click +=
        new Microsoft.Office.Tools.Excel.ActionClickEventHandler(
        colorText_Click);

    colorTag.Actions = 
        new Microsoft.Office.Tools.Excel.Action[] {colorText};
    colorTag.Terms.Add("blue");
    this.VstoSmartTags.Add(colorTag);
}

public void colorText_Click(object sender,
    Microsoft.Office.Tools.Excel.ActionEventArgs e)
{
    e.Range.Font.Color = ColorTranslator.ToOle(Color.Blue);
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.