Cannot run the macro 'Main'

[Gopi_Krishna1 (Gopi Krishna)]

Cannot run the macro ‘Main’. The macro may not be available in this workbook or all macros may be disabled. I am getting this error how to overcome it.

[vrdabberu (Varunraj Dabberu)]

Hi @Gopi_Krishna1

Have you enable the macros. If not follow the below steps to enable Macro settings

Once you go to the below mentioned view by clicking the file option in excel then you please follow the steps:

After going to macros please enable all those settings and then please run the code.

Regards

[Gopi_Krishna1 (Gopi Krishna)]

I have done this, but still getting this error

[vrdabberu (Varunraj Dabberu)]

Can you share the screenshots if possible @Gopi_Krishna1

Regards

[Gopi_Krishna1 (Gopi Krishna)]

Getting Like this: Invoke VBA:Cannot run the macro ‘Main’. The macro may not be available in this workbook or all macros may be disabled.

[vrdabberu (Varunraj Dabberu)]

Hi @Gopi_Krishna1

Have you passed the sheet name and method name correctly. If possible share the workflow.

Check out the thread too

<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

I’ve enabled in trust settings. PFA snip for reference. [image] But it’s still giving issue. FYI, a. VBA script is being saved in notepad file with .vbs extension as well. b. Enable All is being put in Excel application as well c. Excel is being saved as .xlsx d. VBA code I am trying to run: Sub PC_Exists_in_SAP() Columns(“A:B”).Select Selection.Copy Sheets("Mon Sheet 1 ").Select Columns(“A:A”).Select Selection.Insert Shift:=xlToRight End Sub Please help. Thanks in advance.

Regards