Solved

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

Posted on 2011-03-09
5
1,890 Views
Last Modified: 2012-06-21
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
Comment
Question by:garryshape
  • 3
  • 2
5 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35083976
I think that setting is per user rather than per machine (based on the Administrative templates for 2007 group policy.)
0
 

Author Comment

by:garryshape
ID: 35084627
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35084898
Not that I'm aware of, but this is not really my area. :)
0
 

Author Comment

by:garryshape
ID: 35085675
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
 

Author Comment

by:garryshape
ID: 35085690
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most frustrating experiences a help desk technician will ever encounter is when a customer comes to them with a solution of their own invention and expects the tech to implement it. This often happens when people with a little bit of tech…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question