how do I hyperlink to a named range in another workbook?

[nadavrock]

how do i hyper link to a named range in another work book?

i have:
='4. multi excel 4.xlsm'!totalnegative

but it doesnt work

 

[Yongle]

To hyperlink this method works
=HYPERLINK("C:\Folder\Sub Folder\4. multi excel 4.xlsm#totalnegative", "Goto myNamedRange")

 

[Yongle]

To return the value from named range totalnegative in another workbook named 4. multi excel 4.xlsm

='C:\Folder\Sub Folder\4. multi excel 4.xlsm'!totalnegative

 

[nadavrock]

thank you yongle that did it. if relevant to anyone in the future an annoyting secruity pop up appears. solved by editing regkeys by this link https://www.technipages.com/disable-hyperlinks-can-be-harmful-to-your-computer-and-data-message