i have a microsoft excel document with 32 sheets of urls that are plain text
and not clickable. i want to be able to convert all the links to be able to
click on them. they are in full url format (http://www.site.com) i think
someone used this code to convert them into plain text urls:
================================================== ===
1.Same process as a MS Word document. From Excel, fire up the VB editor (ALT
F11).
2.The Visual Basic interface will open up. From the INSERT menu, click on
MODULE to add a module.
3.A new document opens up. In there, paste the following code:

Sub RemoveHyperLinksGLobally()
Dim i As Integer
For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
ActiveSheet.Hyperlinks(i).Delete
Next i
End Sub
============================================
my question is:
how do i convert them into clickable links. thank you

use a helper column. =hyperlink(a1).

assuming A1 had the text. copy/paste down. you'll have to keep both the
formulas and the text, but it will work.

"Gold9er" wrote:

i have a microsoft excel document with 32 sheets of urls that are plain text
and not clickable. i want to be able to convert all the links to be able to
click on them. they are in full url format (http://www.site.com) i think
someone used this code to convert them into plain text urls:
================================================== ===
1.Same process as a MS Word document. From Excel, fire up the VB editor (ALT
F11).
2.The Visual Basic interface will open up. From the INSERT menu, click on
MODULE to add a module.
3.A new document opens up. In there, paste the following code:

Sub RemoveHyperLinksGLobally()
Dim i As Integer
For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
ActiveSheet.Hyperlinks(i).Delete
Next i
End Sub
============================================
my question is:
how do i convert them into clickable links. thank you