Getting error when using Invoke VBA within Excel file

Hi all, I’m trying to work out why I’m getting the following error when I use the Invoke VBA activity within an Excel Application Scope for one of my Excel files which is in .XLSM format.

“Invoke VBA: Can’t perform operation since the project is protected”

I have enabled the option to “Trust access to the VBA project object model”

Would appreciate any insight!

image

@kerri.tiam2

Did you set Enable All option to Macro settings field in Excel Application Scope activity or not ? If not then please check it and then try once.

Hi @kerri.tiam2

Refer to the thread below!

Regards