Page 1 of 1

Hyperlink run macro

Posted: Sat Aug 15, 2015 10:53 am
by 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

Re: Hyperlink run macro

Posted: Sat Aug 15, 2015 11:29 am
by Villeroy
clag wrote: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.
clag wrote: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

Re: Hyperlink run macro

Posted: Tue Nov 22, 2016 12:27 am
by lodovi
Hello, is some similar solution as hyperlink to run macro also for LibreOffice? Or is it posible only with button?

Re: Hyperlink run macro

Posted: Tue Nov 22, 2016 5:00 pm
by Villeroy
lodovi wrote: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.

Re: Hyperlink run macro

Posted: Tue Nov 22, 2016 9:22 pm
by lodovi
Thank you for information. Realy after upgrade it is worked now. Super.