Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2027
  • Last Modified:

Excel 2007 - enforce "Trust access to the VBA project object model"

Is there a way to enforce a local setting on a PC (a PC that will be imaged) to enforce the "Trust access to the VBA project object model" setting?
Like a registry tweak or something to enforce this setting for any user that loggs onto the computer (vm image)?


vba.png
0
garryshape
Asked:
garryshape
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
I think that setting is per user rather than per machine (based on the Administrative templates for 2007 group policy.)
0
 
garryshapeAuthor Commented:
Ok thanks, I guess I'll have to use the group policy templates.
Unless there's any other way in registry to do it?
0
 
Rory ArchibaldCommented:
Not that I'm aware of, but this is not really my area. :)
0
 
garryshapeAuthor Commented:
I ran this app from Nirsoft (http://www.nirsoft.net/utils/reg_file_from_application.html) and monitored Excel as I made the change.

After I enabled the setting, it showed this in the capture window:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"AccessVBOM"=dword:00000001

So that might be the right setting. I'll have to test it.
0
 
garryshapeAuthor Commented:
Nvm that's still an HKEY Current User. So unless I can put it as a long script somehow, I'll have to ensure an Office 2007 AD template can be applied in this environment.
Or just tell user's how to execute a few mouse clicks to enable it themselves.....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now