I got this database in which many institutions had their URL in a column but
all of them in a text format. In order to make them aHyperlink I have to go
into each cell place the cursor then "enter" converting each cell into a
hyperlink. I was wondering if this could be accomplishe in a more automated
form since I have 5,000 entries.
--
Always Learning


"Don Guillett" wrote:

Why clog up with a bunch of hyperlinks. Why not just have the typed url in a
list with a double_click event to go there.

Right click sheet tabview codeinsert this. type something like
desiredwebsite.com in a cell and just double click on the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveWorkbook.FollowHyperlink _
Address:="http://www." & Target
End Sub


--
Don Guillett
SalesAid Software

"Mareadito Siempre" wrote in
message ...
In excel how do I convert a column that has URL adresses in text form to
hyperlink withouthaving to select each cell place the cursor in it and hit
enter to convert it?
--
Always Learning