You can enable macros in Excel using the Trust Center or enable a specific macro from the security warning at the top of a spreadsheet.

%BQUOTE and %NRBQUOTE mask values during execution of a macro or a macro language statement in open code. These functions instruct the macro processor to resolve a macro expression as far as possible ...

When you automate Excel functions with macros using Visual Basic for Applications, Excel doesn't know a macro is controlling execution and continues to issue user notifications and prompts. There are ...