Removing Smart tags

H

Hari Prasadh

Hi,

Excel 2002, XP Pro SP2.

I have Place (could be state, city etc) names in a workbook.

I dont want smart tags to disturb me in each of the cells which contain
place/city data.

Rightclicking such a smart tag option gives one the ability to remove smart
tag only from that cell.

Im not able to select cells enmasse and remove the smart tags in all them at
one go. (couldnt find that option)

Is there an option which would let me turn OFF smart tags ONLY for the
specified workbook.?

I did record a macro for a single cell and changed the option to active cell
below.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 7/1/2005 by Hari Prasadh
'

Range(ActiveCell.Address).SmartTags("urn:schemas-microsoft-com:eek:ffice:smarttags#place").
_
Delete

End Sub

I thought I would add a For loop in the above and make it run for specified
number of times by updating active cell address and a counter.

But, if a cell doesnt have smart tag I get an error.

Please guide me.

Thanks a lot,
Hari
India
 
H

Hari Prasadh

Hi Charlie,

I tried that but couldnt see an option which would let me turn off Tags in a
particular workbook only.

Thanks a lot,
Hari
India
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top