Hi,
I suggest you go to File- Options- Trust Center- Trust Center settings...- Macro Settings- check Enable all Macros.
Try this method and confirm if it will help you, you can also refer to this support article to get more information:
Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.