You can enable the Macros in OpenOffice by following steps:
Click on Tools
Click on Options
Click on Security
Press on "Macros Security"
Select "Medium" and add "Trusted Sources".
You can add the folder to the Trusted Sources where your file exists which contains the Macro. Avoid giving path of directory like Download folder of browser, where you might be downloading un-secure files.