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

While opening web ADI below issue may arise.


For resolving this issue follows below steps
Step - 1 : Go to excel and click on Office Button. Click on Excel Options

Step - 2: Go to Trust Centre Tab. Click on Trust Centre Settings

Step - 3: Go to Macro Settings Tab. Enable check box Trust Access to the VBA project object model

Step - 4: Click on ok

Step - 5: Click on ok

Step - 6: Restart the Machine and open the web ADI.


Post a Comment