Solution For Runtime Error Visual Basic Problem

Asked By 0 points N/A Posted on -
qa-featured

I am trying to run visual basic code but constantly I am getting a runtime error visual basic. I am trying to fix it but it’s not working. Please someone help me with this.

SHARE
Answered By 0 points N/A #299420

Solution For Runtime Error Visual Basic Problem

qa-featured

This error mostly occurs while programmatically allowing access to an Excel 2007 project.

To solve this-

  1. Click Microsoft office button and then go to Excel options
  2. Then click on trust centre and then go to trust centre settings
  3. Then in macro settings tick mark the trust access to VBA box.
  4. Click ok

This solves the problem and the error comes no more.

Related Questions