Share via

DisplaySmartTags Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

XlSmartTagDisplayMode

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.

expression.DisplaySmartTags

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

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

  Sub CheckDisplayOptions()

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