Smart tags are intended to identify particular data and then provide the action options available based on the data type identified. The actions are available via a button that becomes visible close to the cell that contains the data. The button is displayed when the cell is activated, or whenever you move the mouse pointer over the cell.
Smart tags are one of the most useful features that have been enhanced in VSTO 3.0. VSTO smart tags are much easier to use and easy to understand. You can easily customize the actions more strongly than with standard texts. Another good feature is that you have access to the Range
object of the standard texts.
By default, smart tag functionality is turned off in Microsoft Office Excel 2007. VSTO smart tags can be used only in document-level projects for Excel 2007.
First, you need to turn on the smart tag recognition functionality. To do this, execute the following procedure.
Open Visual Studio 2008 and create a new solution...