Please, see http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_a_simple_macro http://ooo.pingju.org/wiki/创建一个简单的宏<http://ooo.pingju.org/wiki/%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AA%E7%AE%80%E5%8D%95%E7%9A%84%E5%AE%8F>（for Chinese）
In your Calc document, write macro as follow.
sub Main
end sub
sub Mymacro
MsgBox("Hello world!")
end sub
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/How_to_run_a_macro
http://ooo.pingju.org/wiki/如何运行宏（for Chinese）
Run macro by event.
In addition, a macro will not autorun until security of macro were low.
