Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink cells between workbooks
Can I create a HYPERLINK from one WORKBOOK to ANOTHER WORKBOOK? I don't want
just a regular link that returns the value of the second workbook, but I want users to be able to click on the cell/text and go to that second workbook. Would it be a MACRO? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink cells between workbooks
Hi Clark:
You don't need a macro. Say you have two workbooks on you desktop: Book1.xls & Book2.xls open Book1.xls and in an un-used cell: Insert Hyperlink and select Existing File and browse to the desktop Then select Book2 as the link target When you click on the hyperlink in Book1, it will take you to Book2. It will open Book2 if it is not already open. -- Gary's Student "Clark" wrote: Can I create a HYPERLINK from one WORKBOOK to ANOTHER WORKBOOK? I don't want just a regular link that returns the value of the second workbook, but I want users to be able to click on the cell/text and go to that second workbook. Would it be a MACRO? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link cells in two workbooks that change daily? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
a quick way to hyperlink 2000 of cells ? | Excel Discussion (Misc queries) |