Removing Automated Hyperlinks (e-mail)

  • Thread starter Thread starter Tonckawa
  • Start date Start date
T

Tonckawa

I am having to create a spreadsheet list of local
technicians. We have quite a few. I have to put in their
e-mail address and when I do, it automatically puts it as
a hyperlink.

I cannot figure out how to turn this automatic function
off. I have to waste time and right-click on the
hyperlink and choose Remove Hyperlink on each cell.

Is there a way to turn off this automatic hyperlink
function within the worksheet?

Thank you.
 
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

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

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module 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
 
unfortunately, I am using Excel 2000. Do you know how
that version?

Thanks again.

Bruce

-----Original Message-----
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

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

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module 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


"Tonckawa" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start the cell with a '
Excel see it as text then
 
Back
Top