Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel-> Make hyperlinks active in cells

Status
Not open for further replies.

tav1035

MIS
May 10, 2001
344
US
I have a worksheet that has internet addresses to websites.
Since I pasted these into excel, the text is not an active hyperlink.
I need some VB to activate either the whole worksheet or a range to make the links active (hyperlinks).
I've tried all sorts of macros to accomplish this but can't seem to get it.

ie.
Code:
[URL unfurl="true"]http://www.msn.com[/URL]

If I click into the cell, (as if I were going to edit), and then click out, the text (
Code:
[URL unfurl="true"]http://www.msn.com[/URL]
) becomes a hyperlink to MSN.
How can I accomplish this over a large scale.
tav
 
Well I found a solution by TonyJollans.
thread707-658989
It was an easy fix->
Place =HYPERLINK(A1) in B1 and drag down.
Thanks Tony.

Other solutions are also welcomed.
tav
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top