Solved

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

Posted on 2011-03-09
5
1,870 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DBF to ... Converter 5 45
What is format f12.8 for a CSV file 6 41
Excel Automation VBA 19 38
Manually enter date in datepicker 24 36
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now