How to override a hyperlink
 

Hi all,

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

A B
1 Email

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



--
thank you so much for your help

How to override a hyperlink
 

Clara,

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


--
Hope that helps.

Vergel Adriano


"clara" wrote:

Hi all,

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

A B
1 Email

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



--
thank you so much for your help

How to override a hyperlink
 

Hi Vergel,

I am using Excel 2000.



thank you so much for your help


"Vergel Adriano" wrote:

Clara,

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


--
Hope that helps.

Vergel Adriano


"clara" wrote:

Hi all,

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

A B
1 Email

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



--
thank you so much for your help

How to override a hyperlink
 

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=F alse

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






--
Hope that helps.

Vergel Adriano


"clara" wrote:

Hi Vergel,

I am using Excel 2000.



thank you so much for your help


"Vergel Adriano" wrote:

Clara,

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


--
Hope that helps.

Vergel Adriano


"clara" wrote:

Hi all,

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

A B
1 Email

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



--
thank you so much for your help