When I make a table in Excel, I have one column for web-addresses. These
become links that I get connected to every time I try to copy the content of
the fields, but I just want it to be a text-field. How do I disconnect the
automatic link-function?
Thank you.

type a ' (single quote) before http://

HTH
--
AP

"Tomas Barth" <Tomas a écrit dans le
message de news: ...
When I make a table in Excel, I have one column for web-addresses. These
become links that I get connected to every time I try to copy the content
of
the fields, but I just want it to be a text-field. How do I disconnect the
automatic link-function?
Thank you.

Right-click the hyperlink you want to deactivate, point to Hyperlink on
the shortcut menu, and then click the last item Remove Hyperlink.


Tomas Barth wrote:
When I make a table in Excel, I have one column for web-addresses. These
become links that I get connected to every time I try to copy the content of
the fields, but I just want it to be a text-field. How do I disconnect the
automatic link-function?
Thank you.

Hi Tomas

In 2002 and up you can change this

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


"Tomas Barth" <Tomas wrote in message ...
When I make a table in Excel, I have one column for web-addresses. These
become links that I get connected to every time I try to copy the content of
the fields, but I just want it to be a text-field. How do I disconnect the
automatic link-function?
Thank you.