How to prevent hyperlinks?
 

What property of a Range can be set so that text within the range is not
interpreted as a hyperlink?

Thanks again,

Keith

How to prevent hyperlinks?
 

There isn't a property of a range to do this. You can go to the
Tools menu, choose AutoCorrect Options, then the "Autoformat As
You Type" tab, and uncheck "Internet and network paths with
hyperlinks" option. This will apply to new data entry. It won't
change existing entries. You can delete hyperlinks and leave the
text intact with

Sub DeleteHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"keithb" wrote in message
...
What property of a Range can be set so that text within the
range is not
interpreted as a hyperlink?

Thanks again,

Keith

How to prevent hyperlinks?
 

Take a look he

http://www.mcgimpsey.com/excel/nohyperlinks.html

In article ,
"keithb" wrote:

What property of a Range can be set so that text within the range is not
interpreted as a hyperlink?

Thanks again,

Keith