Errors occurred during load while opening a macro

I am using office 365, When I open a Macro enabled excel sheet through an windows .net application it throws an error Microsoft Visual Basic "error occurred during load". Then will display error: Cannot run the macro <macro_name>.The macro may not be available in this workbook or all macros may have been disabled".

I tried both repairing office and reinstalling, it dint work out, could you please suggest some solution for this