software

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

quot;Gold9erquot; wrote:

gt; i have a microsoft excel document with 32 sheets of urls that are plain text
gt; and not clickable. i want to be able to convert all the links to be able to
gt; click on them. they are in full url format (www.site.com) i think
gt; someone used this code to convert them into plain text urls:
gt; ================================================== ===
gt; 1.Same process as a MS Word document. From Excel, fire up the VB editor (ALT
gt; F11).
gt; 2.The Visual Basic interface will open up. From the INSERT menu, click on
gt; MODULE to add a module.
gt; 3.A new document opens up. In there, paste the following code:
gt;
gt; Sub RemoveHyperLinksGLobally()
gt; Dim i As Integer
gt; For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
gt; ActiveSheet.Hyperlinks(i).Delete
gt; Next i
gt; End Sub
gt; ============================================
gt; my question is:
gt; how do i convert them into clickable links. thank you