Ask Your Question

How do I change hyperlink file to %userprofile% folder? [closed]

asked 2019-10-27 22:39:04 +0100

Potatismoose gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-10-28 12:10:52.471235

1 Answer

Sort by » oldest newest most voted

answered 2019-10-27 23:41:36 +0100

erAck gravatar image

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

edit flag offensive delete link more


Thank you, solved my problem!!

Potatismoose gravatar imagePotatismoose ( 2019-10-28 01:09:01 +0100 )edit

Question Tools

1 follower


Asked: 2019-10-27 22:39:04 +0100

Seen: 226 times

Last updated: Oct 27 '19