Getting error when using Invoke VBA within Excel file

[kerri.tiam2 (Kerri Tiam)]

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!

[lakshman (Ganta lakshman)]

@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.

[pravin_calvin (pravin kumar)]

Hi @kerri.tiam2

Refer to the thread below!

Execute Macro Doesn't work

Dear UIPath community, I made a simple process where I’m using the “Execute Macro” activity inside an “WindowScope” activity inside “ExcelApplicationScope”. I made an xlsx Excel file with a simple macro in it “Tableau1”. Each time I start the robot my Excel file opened and then I get this error : unable to run the macro “Tableau1”, it may be unvailable in this workbook or all macro are disabled. Is anyone know what could be wrong here ? I already try all solution found with internet …

Regards