#1
|
|||
|
|||
worksheet-name independent hyperlinks
I just found this post on hyperlinks
http://excel.bigresource.com/Track/excel-ClIe789E/ I have a couple questions on that. And was wondering if hopefully somebody would be able to answer them. I really would appreciate if you could help me. I have a big workbook, with a lot of sheets and every sheet has a number of hyperlinks on it. 1. Now the names of the sheets will change in the future quite often. 2. The hyperlinks that I have in my spreadsheet are linked to certain cells within the same sheet, those cells have been defined with a name. The hyperlinks are linked to that specified name, to prevent the links from failing, when I insert rows or columns Question: How can I create a hyperlink to those cells, which are defined by a name, so that I don't have to worry about name changes of the sheet? And here is my second question. I have cells that are referencing other cells but are supposed to be a hyperlink to a different sheet at the same time. Again that hyperlink has to be independent of the names of the sheets. Is there a possible solution for that? Maybe by using the code name, that you can find in the vb-editor? I really would appreciate your help. I am stuck on this for a couple days already. Thank you very much. Jon |
#2
|
|||
|
|||
Hi Jon
You can do this using VBA. However I am not a VBA expert. May I suggest you re-post your question to say something like: "I need a VBA routine to check Hyperlinks on Sheet1 that refer to sheets where the name is changed and re-set the hyperlink to the changed name." I know there are some super VBA people on the forum that will provide this with ease. Hope this helps. Tony (OTPM) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Worksheet copying? | markg2 | Excel | 4 | 01-07-2010 10:08 AM |
Independent columns | jdthelen | Word | 2 | 09-17-2009 09:34 PM |
Independent tables/filters | Wries | Excel | 0 | 07-28-2009 04:16 AM |
independent hyper link execl & word | tambal | Excel | 1 | 05-20-2009 03:07 PM |