Link for Web Address in Worksheet cells

  • Thread starter Thread starter David
  • Start date Start date
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.
 
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
 
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!
 
Back
Top