Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink question
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink question
Yes, but you will be in workbook2, not just see what is in the cell.
Do insert=Hyperlink, in the dialog, in the top box, hit browse and select you workbook Click in the bottom box and click browse, then select sheet and reference (cell address) for example (from the immediate window) ? activecell.Hyperlinks(1).Address C:\Data\aa_dateposition.xls ? activeCell.hyperlinks(1).SubAddress Sheet2!B9 Regards, Tom Ogilvy xnman wrote in message ... Is there a way to set a hyperlink in a cell of workbook1 pointing to a specific cell in workbook2 so that when you click on the cell you see what is in the specific cell in workbook2? -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Worksheet Functions |