| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink stored in an external workbook
I:
1. entered: file:///c:\documents and settings\owner\desktop\ballon.doc in cell C3 in Shared.xls 2. named C3 as mPolicy1 3. entered: = Shared.xls!mPolicy1 in cell A1 in user.xls ( this displayed that same hyperlink, but was "cold") 4. entered: =Hyperlink(A1) in cell A2 in user.xls ( same display, but "clickable") Word doc opens with no problem. -- Gary''s Student - gsnu2007a |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
| Excel 2007 - hyperlink to display external data in a pop-up? | Excel Worksheet Functions | |||
| External hyperlink to a specific page in a workbook | Excel Worksheet Functions | |||
| VLookup to an external Workbook | New Users to Excel | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Hybrid Mode
