Just started learning about openoffice so I might be missing something. I've already searched the forum and google for 2 days (maybe I'm not getting the keywords / terms right?)
I have a report generated by a macro, now one of the fields namely Col A contains a hyperlink. This hyperlink also calls a macro.
Code: Select all
=HYPERLINK("vnd.sun.star.script:Standard.Link.Show?language=Basic&location=document";ROW()-1)
ie :
If I click on the hyperlink in "A1" will display a msgbox containing the value of "B1","C1",.....
If I click on the hyperlink in "A2" will display a msgbox containing the value of "B2","C2",.....
and so on
Thanks