Auto run macro on open

I read an .xlsm file in Calc5, it has an auto run macro at open. How can I get that macro to run when file open in Calc5?
Now it’s not getting executed when open with Calc5. If I execute the macro by itself, it’s working. So the coding is good.
Best regards.