Monday, May 10, 2021

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.


No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...