Hi,
Check if the macro is disabled:
1.
Click
File > Options.
2.
Click
Trust Center.
3.
Click
Trust Center Settings.
4.
Click
Macro Settings.
If it is not disabled, you can post the content of your macro here, and we will check for you.
Best Regards,
Sally Tang