Microsoft Visual Basic Run-time error '1004': Method 'VBProject' of object '_Workbook' failed

To fix this issue, pls perform the below setups in MICROSOFT EXCEL to accept the WEBADI transaction in VBProject Workbook.

In Excel, use the following navigation:

Step 1: Open the Microsoft Excel and go to FILE à OPTIONS

Step 2: On the left, click on the Trust Center

Step 3: Click on the Trust Center Settings button and go to Macro Settings and Click on “Trust access to the VBA project object model”