SmartTagOptions Object [Excel 2003 VBA Language Reference]
Workbook SmartTagOptions |
Represents the options that can be performed with smart tags.
Using the SmartTagOptions object
Use the SmartTagOptions property of the Workbook object to return a SmartTagOptions object.
Once a SmartTagOptions object is returned, you can use the following properties to determine the display options of smart tags and whether or not to have smart tags be embedded on the active workbook.
This example enables the ability to embed smart tags on the active workbook and then checks the display settings for smart tags.
Sub CheckDisplayOptions()
'Enable SmartTags to be embedded on the active workbook.
ActiveWorkbook.SmartTagOptions.EmbedSmartTags = True
' 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
Properties | Application Property | Creator Property | DisplaySmartTags Property | EmbedSmartTags Property | Parent Property
Parent Objects | Workbook Object
Child Objects
See Also | SmartTag Object | SmartTagAction Object | SmartTagRecognizer Object