INVOKE VBA Macro

[Sisay]

Why can’t I run INVOKE VBA?
This is my error
Invoke VBA: Cannot run the macro ‘CheckEquals’. The macro may not be available in this workbook or all macros may be disabled.
Excel Application Scope: Cannot run the macro ‘CheckEquals’. The macro may not be available in this workbook or all macros may be disabled.

[AJ_Ask]

Hi @Sisay

Is your macro running correctly in your Excel?

Is the name of the macro is correct?

Also check this thread

<Excel VBA> Invoke VBA: Cannot run the macro 'PC_Exists_in_SAP'. The macro may not be available in this workbook or all macros may be disabled

Hi Error indicates that the macro that you are trying to run is not available in the workbook or that macros are disabled on the machine where you are running the script. It could be like The macro is in a different workbook than the one that you are trying to run the script in. The macro was deleted from the workbook. The macro was disabled in the workbook. But the most common cause of this issue is related to macro security settings in Excel. Macros may be disabled or set to a high secur…

[mkankatala (Mahesh Kankatala)]

Hi @Sisay

Check the below thread, it might helpful for you…

<Excel Macro Issue> Invoke VBA - Macro1: Cannot run the macro 'Macro1'. The macro may not be available in this workbook or all macros may be disabled

I am facing this issue for long! File is saved in .xlsx format. No macros or VBA script is inside the excel. I am using all the macros/formulae saved in text file and then using Excel application scope and inside it Invoke VBA. Any help would be highly appreciated.

Hope it helps!!