Execute Excel Macro

Hi Forum,

I have been tinkering with this excel for several days, and find no solution. Have also implemented several solutions from the forums but I still cannot solve mine. Its actually a simple flow of running an excel which contains a macro that if I run that macro it will change the formatting of another workbook.

the problem is, I got the message “Execute Macro: Cannot run the macro ‘RunMacroInOtherWB’. The macro may not be available in this workbook or all macros may be disabled” when executing the macro. I have tried another by separating the excel and vbs, but got “HRESULT: 0x800A03EC” instead, i have put kill process but not solving either.

so what is the best approach for this, and how do i fix this? appreciate any answers

TrialRunMacroAnotherWB.zip (44.8 KB)


In Excel Application Scope ->MacroSettings->Enable All

After Enable All i am not getting any error

Hope this may helps you


hey, thanks for the answer.
but nope, I have done that far before this, and still wont do anything.
there is something with my excel that to access my macro/ vba screen i have to manually open excel, browse, choose my macro file. otherwise, excel will gray out visual basic and macro

is this is possibly the root of the problem?


Yes, that could be a problem

It was disabled, maybe it is a group policy

Check below for your reference

Hope this helps you


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.