Link for Web Address in Worksheet cells

D

David

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.
 
D

Dave Peterson

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
 
O

Opinicus

Dave Peterson said:
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.
Click to expand...

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