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!



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!