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:office: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

Try Tools--Options--Spelling and click on AutoCorrect Options.

"Hari Prasadh" wrote:

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:office: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

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

"Charlie" wrote in message
...
Try Tools--Options--Spelling and click on AutoCorrect Options.

"Hari Prasadh" wrote:

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:office: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