We have a customized macro that needs to be activated. Do you have a guideline on how to activate and run it?  

You need to copy the macro in the System folder
C:\Program Files (x86)\Trados\Passolo\Passolo 2022\Macros
C:\Program Files (x86)\SDL\SDL Passolo\SDL Passolo 2018\Macros

or change the folder as described here: http://producthelp.sdl.com/SDL_Passolo_2016/en/html/Options/systemfolders.htm

Please find here more details on how to use the macro in Passolo: https://docs.sdl.com/881527/453450/sdl-passolo-automation/using-macros-in-passolo

Also, please have in mind that we don't offer support for macro and automation, but you can post any questions on the forum at:
https://community.rws.com/product-groups/trados-portfolio/passolo/f/object-model