SmartTagOptions.DisplaySmartTags Property

  • Article
Excel Developer Reference

Returns or sets an XlSmartTagDisplayMode constant indicating the display features for smart tags. Read/write.

Syntax

expression.DisplaySmartTags

expression   A variable that represents a SmartTagOptions object.

Remarks

XlSmartTagDisplayMode can be one of these XlSmartTagDisplayMode constants.
xlButtonOnly. Displays only the button for smart tags.
xlDisplayNone. Nothing is displayed for smart tags.
xlIndicatorAndButton. Display the indicator and button for smart tags.

Example

In this example, Microsoft Excel determines the setting for displaying smart tags and notifies the user.

Visual Basic for Applications 
  Sub CheckDisplayOptions()

' Check the display options for smart tags.
Select Case ActiveWorkbook.SmartTagOptions.<strong>DisplaySmartTags</strong>
    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