Need Hyperlink to use Relative Reference, defaulting to absolute

[lgia]

I have a ? Icon in a few areas in my spreadsheet to use as a hyperlink to jump to another worksheet in the same workbook to a named cell. I select the icon and EDIT HYPERLINK I select PLACE IN THIS DOCUMENT and select the named cell from a list. when I hover over the link, it shows an absolute path from the C drive to the name of the workbook.

I need to distribute the workbook so that people can store it in any folder and even rename it. The worksheet is locked so they cannot rename the worksheet or the cell. I cannot find anyway I can edit the absolute path to make it relative, although it appears to be relative when I edit the hyperlink.

Although this wont help click on my graphic.. I tried using =HYPERLINK(named cell) and =HYPERLINK(A2) as a test and that doesn't even work! I don't know what else to try!

 

[FDibbins]

Here is a method to add a H/L with a formula instead...
=HYPERLINK("#"&"'"&A2&"'!A1",A2)
A2 contains the sheet name - or you could just type in the name
=HYPERLINK("#"&"'"&"sheet1"&"'!A1","Sheet1")
the 2nd reference to A2 puts the sheet name into the HL, and the A1 reference takes you to A1 in sheet2

 

[lgia]

The first hyperlink example, I get an error 'unrecognized text' but the second hyperlink works great. I don't really understand how it works though , what does the # represent? Is there a way to used the named cell in this function? if not, that's okay this works!