Hello,
Each user of the OS that runs LibreOffice has its own .config folder with its own Module1.xba. This .config folder is always in the home folder of the user. /usr/lib/libreoffice/presets/basic/Standard/Module1.xba isn't a home folder, and the macro needs to be added to the Module1.xba of the user that is running LibreOffice.
Regards.