Share via


Workbook.SmartTagOptions Property

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