Link for Web Address in Worksheet cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 12 Sep 2007 09:49 GMT

I have a worksheet I use as a phonebook. It contains a lot of info
including web addresses.

I have no need & do not want to click on a web address in this
worksheet & start my browser. I would like to convert all the web
addresses in this particular worksheet to "pure text".

Is this possible? If so, I'd appreciate knowing how to do it.

Reply to this Message

Dave Peterson - 12 Sep 2007 12:50 GMT

Select all the cells you want to fix (the whole worksheet is ok, too).

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Close this window and go back to excel to check it out.

Depending on the version of excel you're using, you can toggle a setting so you
don't get these addresses turned into links:

(xl2003 menu system)
Tools|AutoCorrect Options|AutoFormat As You Type tab
Uncheck that first option

> I have a worksheet I use as a phonebook. It contains a lot of info
> including web addresses.
[quoted text clipped - 4 lines]
>
> Is this possible? If so, I'd appreciate knowing how to do it.

Signature

Dave Peterson

Reply to this Message

Opinicus - 12 Sep 2007 13:42 GMT

> Select all the cells you want to fix (the whole worksheet is ok, too).
>
[quoted text clipped - 4 lines]
>
> Close this window and go back to excel to check it out.

That is too cool, sir. Many thanks for that!

Signature

Bob
http://www.kanyak.com

Reply to this Message