Writing Excel Macros with VBA, 2nd Edition

Name

SmartTag Related Objects

Synopsis

Path: Application  --  Range  --  SmartTags - SmartTag  -- SmartTagActions  --  SmartTagAction; 
Path: Application  --  Workbook  --  SmartTagOptions; 
Path: Application  --  SmartTagRecognizers - SmartTagRecognizer

Object	Methods	Properties
SmartTag	Delete( )	DownloadURL( ) As String Name( ) As String Properties( ) As CustomProperties Range( ) As Range SmartTagActions( ) As SmartTagActions XML( ) As String
SmartTags	Add(SmartTagType As String) As SmartTag	Count( ) As Long
SmartTagAction	Execute( )	Name( ) As String
SmartTagActions		Count( ) As Long Item(Index As Variant) As SmartTagAction
SmartTagOptions		DisplaySmartTags( ) As XlSmartTagDisplayMode EmbedSmartTags( ) As Boolean
SmartTagRecognizer		Enabled( ) As Boolean FullName( ) As String progID( ) As String
SmartTagRecognizers		Count( ) As Long Item(Index As Variant) As SmartTagRecognizer Recognize( ) As Boolean

This collection of objects enables programmatic control over existing Smart Tags. Note that in order to create custom Smart Tags, we need need to use an application that can create COM DLLs, such as Visual Basic or Visual C++. Custom Smart Tags cannot be created in Excel XP. For more on Smart Tags, please see Chapter 22.