I would like to turn off whatever it is that makes live hyperlinks out of
everything with an @ in it. Any ideas?

Hi sweetj95-

Go to ToolsAutocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....

HTH |:)

"sweetj95" wrote:

I would like to turn off whatever it is that makes live hyperlinks out of
everything with an @ in it. Any ideas?

Go to ToolsAutocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....

Thank you for the response, but I don't have an AutoFormat As You Type page.
Maybe I'm working with a different version. My Autoformat box has only one
tab, "AutoCorrect". The Options a
Correct TWo INitial CApitals
Captilalize first letter of sentence
Capitalize names of days
Correct accidental cAPS lOCK
Replace Text as you type

And there's an Exceptions box.

Hi

In 2002/2003 you can turn it of

Tools Options Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start with a '

You can run this macro also to make text of all hyperlinks
in your worksheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
InsertModule from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run


--
Regards Ron de Bruin
http://www.rondebruin.nl


"sweetj95" wrote in message ...

Go to ToolsAutocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....

Thank you for the response, but I don't have an AutoFormat As You Type page.
Maybe I'm working with a different version. My Autoformat box has only one
tab, "AutoCorrect". The Options a
Correct TWo INitial CApitals
Captilalize first letter of sentence
Capitalize names of days
Correct accidental cAPS lOCK
Replace Text as you type

And there's an Exceptions box.

Apparently you are using Excel 2000 or earlier.

I don't know of a global setting t disable the effect altogether, but you
can right-click a hyperlink cell, point to Hyperlink in the shortcut menu &
choose Remove hyperlink.

BTW- It's always a good idea to specify version when posting.

Good Luck |:)


On 7/15/05 5:54 PM, in article
, "sweetj95"
wrote:


Go to ToolsAutocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....

Thank you for the response, but I don't have an AutoFormat As You Type page.
Maybe I'm working with a different version. My Autoformat box has only one
tab, "AutoCorrect". The Options a
Correct TWo INitial CApitals
Captilalize first letter of sentence
Capitalize names of days
Correct accidental cAPS lOCK
Replace Text as you type

And there's an Exceptions box.