Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
Finding unique items in data field for pivot tables | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |