Solved

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

Posted on 2011-03-09
5
1,845 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
Comment Utility
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
Comment Utility
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
Comment Utility
Not that I'm aware of, but this is not really my area. :)
0
 

Author Comment

by:garryshape
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

7 Experts available now in Live!

Get 1:1 Help Now