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.

Get Writing Excel Macros with VBA, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.