Wednesday, 22 February 2012

Registry - Windows 7 - Windows Explorer Settings

Organize
Folder and search options
Navigation pane
Show all folders
Automatically expand to current folder


create a cmd file with

reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced" /v NavPaneShowAllFolders /t reg_dword /d 1 /f

reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced" /v NavPaneExpandToCurrentFolder /t reg_dword /d 1 /f

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