create a hyperlink field for a tamplate?
I have a template with various fields, when I make use of it, all fields are
displayed correctly. One of this fields is a text string that holds pathname and file name of a document related to the record. I would like to have this string come in as a hyperlink, and not have to go and manually change each cell in the column with the Insert - Hyperlink commands. Does anyone knows how to do this? |
create a hyperlink field for a tamplate?
NEW
If using Excel 2002 or 2003 you can set this up under ToolsAutocorrect OptionsAutoformat as you type. For existing strings a formula in an adjacent cell....... =HYPERLINK(cellref) will return as a hyperlink. Or you can use a macro to convert all at once. Sub MakeHyperlinks() 'David McRitchie Dim Cell As Range For Each Cell In Selection With Worksheets(1) .Hyperlinks.Add Anchor:=Cell, _ Address:=Cell.Value, _ ScreenTip:=Cell.Value, _ TextToDisplay:=Cell.Value End With Next Cell End Sub Gord Dibben Excel MVP On Fri, 18 Nov 2005 09:42:07 -0800, NEWGUY wrote: I have a template with various fields, when I make use of it, all fields are displayed correctly. One of this fields is a text string that holds pathname and file name of a document related to the record. I would like to have this string come in as a hyperlink, and not have to go and manually change each cell in the column with the Insert - Hyperlink commands. Does anyone knows how to do this? |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com