| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to another worksheet in the same workbook
When I hyperlink to another worksheet within the same workbook, I receive
Cannot open specified file. This file will be sent to others so I changed the hyperlink base in properties. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink to another worksheet in the same workbook
I find the =hyperlink() worksheet function much easier to work with.
David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Dgwood90 wrote: When I hyperlink to another worksheet within the same workbook, I receive Cannot open specified file. This file will be sent to others so I changed the hyperlink base in properties. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I 'hyperlink' within a workbook from the first worksheet? | Excel Worksheet Functions | |||
| Find specific worksheet in another workbook and then applu Vlookup | Excel Worksheet Functions | |||
| Customizing Worksheet Menu Bar for a workbook without VBA coding | Excel Discussion (Misc queries) | |||
| Hyperlink problem to cell in same workbook | Excel Worksheet Functions | |||
| Copying worksheet from workbook to another | Excel Worksheet Functions | |||
Hybrid Mode
