Export (0) Print
Expand All
Expand Minimize

DisplaySmartTags Property [Excel 2003 VBA Language Reference]

Office 2003

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 Required. An expression that returns one of the objects in the Applies To list.


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

© 2014 Microsoft