Share via

VBA Run-time Error '70': Permission Denied.

Anonymous
2019-12-19T20:22:33+00:00

BTW, my employer has an Office 365 licence, which is what I'm using.  That option wasn't available in the dropdown .

What I'm trying to do:  I have a userform combobox that I am trying to add some refined search functions to, but I don't know how to code VBA well enough to make that happen.  

What I did:  I copied some code from a forum and modified it to my userform and controls.

What happened:  When I run the code, I get this error message - 

When I click debug, it shows the highlighted line of code:

Any help would be very much appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-22T06:14:47+00:00

    I had the same problem VBA run time error 70

    For me it was a settings in a Antivirus:

    => MalwareBytes\Settings\Security\Advenced Settings\

    Application Hardening

    Prevent loadin VB Script Library : MS Office <Off>!

    May be it can help!

    5 people found this answer helpful.
    0 comments