How to create a hyperlink in calc

[monty]

I am trying to create a spreadsheet with the first worksheet containing a list of client names, and each name is hyperlinked to a specific worksheet that is named for the client. What I am TRYING to do is click on the hyperlink, and the worksheet associated with the client comes to the front so that I can work on it I have followed the instructions explicitly:
Create a named range (A1) on the target worksheet;
Insert a hyperlink in the first worksheet that points to the file, and the target worksheet. Sometimes the range comes up as a target choice, but most times it does not.

The created “hyperlink” is hi-lit as one would expect, but there is no action when I click on it.
I have tried to insert as a button. Whenever I click on the button, it simply chooses the button so that I can delete it - again, no action

Any suggestions?
Thanks
-Monty

[Lupp]

Are you looking for something as is demonstrated in this example?
The HYPERLINK() function should be the appropriate means for the purpose. However, it seems to be a bit fragile in its working if editing is done.
Anyway you don’t need named ranges if it’s ok for you to jump to cell A1 of any chosen sheet.

[monty]

I opened the example spreadsheet which you sent, and the commands seem to make sense, but there is no action when I click on the hyperlinks. Could it perhaps be something I need to set within the preferences for LibreOffice? It seems like this should be pretty straightforward…
(Oh, yes, thank you for your answer!)

[Lupp]

Did you try it with Ctrl+Click? Requiring the ‘Ctrl’ is a common setting to prevent inadvertent activation of links.
Anyway the examle worked for me as intended.

[monty]

When I do the “command”-click (this on a mac) I get the desired result. Thank you so much for your help!
-MOnty