Wednesday, 22 February 2012

Registry - Excel - Trust access to the VBA project object model

Excel 2007 / 2010 -

Options
Trust Center
Trust Center Settings...
Macro Settings
Trust access to the VBA project object model



create a cmd file with

reg add "HKCU\Software\Microsoft\Office\12.0\Excel\Security" /v AccessVBOM /t reg_dword /d 1 /f

reg add "HKCU\Software\Microsoft\Office\14.0\Excel\Security" /v AccessVBOM /t reg_dword /d 1 /f


deploy it per GPO start script

No comments:

Post a Comment