Execute Excel Macro

Help
, ,
1

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)

2

@ramadhan.nugraha

In Excel Application Scope ->MacroSettings->Enable All

After Enable All i am not getting any error

Hope this may helps you

Thanks

3

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

image
image1056×258 21.3 KB

is this is possibly the root of the problem?

4

@ramadhan.nugraha

Yes, that could be a problem

It was disabled, maybe it is a group policy

Check below for your reference
https://social.technet.microsoft.com/Forums/lync/en-US/7c3d637d-453d-4a84-ac44-c1500bed95f4/macro-settings-greyed-out?forum=excel

Hope this helps you

Thanks

5

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