How do i create buttons that link to calc files?

Hi,

I am trying to create buttons which once clicks open up another calc file.
I tried to use the form designer. I cannot get the labels to be renamed to what I need them to.
I need to simply create a button, have text on the button called fred and once clicked, it will open up fred’s calc
file.
It appears that the form designer has never been tested within calc?

You can use the hyperlink dialog Insert > Hyperlink. Use type ‘Document’. In the upper part you can select the file. And in the lower part chose ‘Button’ from list ‘Form’ in part ‘Further settings’.

Thanks - Idid that but nothing happens when I press the button

When you have newly created the button, you are still in Design mode. You have green handles, when you are in Design mode and you can resize the button and move it around. When you save and reload the document, it will no longer be in Design mode but in User mode and you can preform the action. Alternatively to save/reload you can open the toolbar “Form Design” and toggle between Design and User mode with the icon second from left.

great - thanks!