How do I change hyperlink file to %userprofile% folder?

[Potatismoose]

I have a spreadsheet with multiple sheets in. I do not know if there are any other more convenient ways of doing this, in that case please inform me. Anyway, my problem is that I want a button that the user should click to get to the next sheet. The problem? please read on…
Example:

IMPORTANT INFORMATION… bla bla bla bla
“Button to click to get to the next sheet”

When you create a button (hyperlink) you can choose to link it to the same file as you are already in and a specific sheet. So far so good. But I don´t want it to link to a specific user folder. I would like something like this “%userprofile%\desktop\filename.ods” instead of c:\users\sam\desktop\filename.ods. This specific file is going to be placed on more than 20 computers and I do not want to change the hyperlink for every computer due to different user names and therefore different folder names. Is there a way of solving this?

[erAck]

In the button’s Control Properties, for Action select Open document/web page and in the URL field just enter the jump target cell as fragment without document, like #Sheet2.A1

[Potatismoose]

Thank you, solved my problem!!