Hyperlink run macro

[clag]

Hello to all,

in a Writer dokument I want reconfigure with a macro, normal hyperlinks which start a URL to hyperlinks which start a marco.
When new hyperlink is clicked and the macro is called, the hyperlink text should be parameter for the called macro.

I find here a likely question, but I am not able to bring the example code to run.
viewtopic.php?f=45&t=53609

There are two questions
1. how to reconfigure an existing hyperlink that click start a macro?
2. how to make the hyperlink text to a parameter for the called makro?

thanks ahead
clag

[Villeroy]

1. how to reconfigure an existing hyperlink that click start a macro?

Enter another hyperlink in cell A2 or enter more hyperlinks below A2 and copy down the formula in B2.

2. how to make the hyperlink text to a parameter for the called makro?

This is what the demo file tries to demonstrate.

Important note: LibreOffice lost the ability to call macros by URL protocol vnd.sun.star.script:
The feature is back again in LO 5.2

[lodovi]

Hello, is some similar solution as hyperlink to run macro also for LibreOffice? Or is it posible only with button?

[Villeroy]

Hello, is some similar solution as hyperlink to run macro also for LibreOffice? Or is it posible only with button?

The feature is back again in LO 5.2.

[lodovi]

Thank you for information. Realy after upgrade it is worked now. Super.