| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Hyperlink to cell in different sheet
HI.
I want to create a link from one cell to another cell in a different sheet but same workbook. But how can I get the link to follow when adding rows in the linked to sheet? Ie. Cell A5 in sheet1 has a link to cell B7 in sheet2. If I add 2 rows to sheet2 so my previous cell B7 is now B9. I want the link now to go to B9 in sheet2. Is this possible, and if so how? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink - clicking on hyper link to select cell in another sheet | Excel Worksheet Functions | |||
| Hyperlink to a cell, in a different sheet, that cointains a specific taxt | Excel Worksheet Functions | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| Creating a hyperlink to a cell on a different sheet | Excel Worksheet Functions | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
![Regina[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
