Invoke a macro through a hyperlink

kiran.gs · Nov 26th 2015, 8:59am

From a hyperlink on my sheet, can I trigger a macro? I cannot use buttons since I need a hyperlink for each of the rows in a dynarange.

Based on the click of hyperlink, I need certain actions that need to run, and the actions are a part of the macro that I build.

Regards,
Kiran

laloune · Nov 26th 2015, 10:12am

yes you can.

in B1 cell put something like : =if(A1=0,"macro stop",yourmacro())

yourmacro() should look like this:

Source Code

function yourmacro()
{
// reset the macro trigger
activesheet()->range('A1')->value=0;
// do something
}

then you use an hyperlink to set the A1 cell to 1 using transfer values

note: if triggering from a link you cannot use "return" statements (in Jedox 5.1 though, I have not tested in 6 yet)

kiran.gs · Nov 26th 2015, 10:27am

Done this, but, nothing seems to be happening.. in my macro, I have a PALO_SETDATA function. However, I dont see any change to the values.

Looks like the macro is not getting triggered at all.

Kiran

kiran.gs · Nov 26th 2015, 11:04am

It worked.. looks like there was another error in my Macro which was not showing out explicitly. When I right clicked on a cell and clicked "Show Error", it gave me where the error was.

Thanks Laloune. I will also check and see if return works, as I need to have a message box based confirmation to proceed.

Invoke a macro through a hyperlink

Invoke a macro through a hyperlink

Source Code

Share

Similar Threads