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