Hello Denis,
Please don't change the setting for macro to enable all macro - as even they have mentioned the risk over.
An alternative solution for that is, add you macro file location under trusted location, so the excel application will open and execute macro without any issue as it will be treated as trusted file.
Thanks & Regards,
Vijay Rudrappa Dodamani