Cannot run the macro 'Main'

[vrdabberu (Varunraj)]

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