Workbook.SmartTagOptions Property

  • Article
Excel Developer Reference

Returns a SmartTagOptions object representing the options that can be performed with a smart tag.

Syntax

expression.SmartTagOptions

expression   A variable that represents a Workbook object.

Example

In this example, Microsoft Excel notifies the user of the display settings for the smart tag options.

Visual Basic for Applications 
  Sub CheckSmartTagOptions()

' Check the display options for smart tags.
Select Case ActiveWorkbook.<strong class="bterm">SmartTagOptions</strong>.DisplaySmartTags
    Case xlButtonOnly
        MsgBox "The button for smart tags will only be displayed."
    Case xlDisplayNone
        MsgBox "Nothing will be displayed for smart tags."
    Case xlIndicatorAndButton
        MsgBox "The button and indicator will be displayed for smart tags."
End Select



End Sub

See Also