Hello
Thank you for your question and reaching out. I can understand you are having query\issues related to Disabling Macro in Office 365.
Open Excel or Word
Click the File tab.
Click Options.
Click Trust Center, and then click Trust Center Settings.
In the Trust Center, click Macro Settings.
Make the selections that you want, then click OK.
Disable all macros without notification
Tick to Trust access to the VBA project object model
Reference :
--If the reply is helpful, please Upvote and Accept as answer--