Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Trust access to VBA greyed out

    Excel 2010. If I select File > Options > Trust Center > Trust Center Settings... > Macro Settings, I (now) find that everything is greyed out. And the 'Trust access to the VBA project object model' at the bottom is unchecked.
    It didn't used to be that way, so I initially suspected that it was some group policy that the corporate IT dept had implemented. I saw a suggestion to run something called gpedit.msc, but the section that supposedly needed fixing didn't exist.
    I've tried completely uninstalling then re-installing Office, but same story.
    Anybody have any ideas what setting might be causing it to be greyed out?
    TIA

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    I didn't figure out why it's greyed out, but by modifying some registry settings I was able change the checkbox so that it's checked. In case it's helpful to anybody else reading this, I searched the registry for AccessVBOM (presumably Visual Basic Object Model?) and set them to 1 rather than 0.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •