Properties Options for Excel Application Scope


I have 2 different UI project A and B. Proj A is done by other colleague last 2 year which in the Excel Application Scope properties have MacroSetting function. While B is currently doing do not have that function.

Hence, for proj B i am facing Execute Macro: Exception from HRESULT: 0x800A9C68 after my macro finished executed.

I have follow other example to enable the Macro Setting in the excel however if i were to run proj A, it will not work successfully. May i know if what other possible solution than going with the above approach of changing setting in the excel.

Appreciate your kind help.