DisplaySmartTags Property

Microsoft Excel Visual Basic

Show All

DisplaySmartTags Property

       

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

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