How to override a hyperlink

[Guest]

Hi all,

I use Excel 2000, in a sheet I have the following layout:

A B
1 Email (e-mail address removed)

Every time I input in cell B1, the text will be hyperlinked automatically
that is not what I want.Could you tell me how to override it?

Clara

 

[Guest]

Clara,

Go to Tools->AutoCorrect Options. In the "AutoFormat As You Type" tab,
uncheck "Internet and network paths with hyperlinks".

 

[Guest]

Hi Vergel,

I am using Excel 2000.



thank you so much for your help

 

[Guest]

Hi Clara,

I thought you should see the AutoCorrect options under the Tools menu even
in Excel 2000.. One other way to get to it is to go to Tools->Options. In
the Spelling Tab, click on the AutoCorrect Options button.

You can also "uncheck" the option via VBA by:

application.AutoFormatAsYouTypeReplaceHyperlinks=False

If you want to keep the setting to true but want to just get rid of the
hyperlinks after entering all data, you can also do it via vba with something
like:

Range("B:B").Hyperlinks.Delete