Excel: Add trusted location to execute macros when a document is opened


Excel can configured to prevent execute macros when a document is opened.

If you do not want to allow this for all documents and location you can specify some trusted locations. This can be done in Excel or by setting the appropriated registry keys.
This works for local folders on your computer and for network shares. Before set make sure that the new location does not overwrite an existing ones (reg query). When an location exists simply increment the registry key (location100, location101, etc)

reg query HKCU\Software\Microsoft\Office\14.0\Excel\Security\Trusted Locations\location100
reg add "HKCU\Software\Microsoft\Office\14.0\Excel\Security\Trusted Documents" /v DisablePromptOpenNetworkTrustedDocuments /d 1 /t REG_DWORD
reg add "HKCU\Software\Microsoft\Office\14.0\Excel\Security\Trusted Locations\location100" /v AllowSubFolders /d 1 /t REG_DWORD
reg add "HKCU\Software\Microsoft\Office\14.0\Excel\Security\Trusted Locations\location100" /v Path /D "\\yourFileServer\yourShare$\Project" /t REG_SZ
reg add "HKCU\Software\Microsoft\Office\14.0\Excel\Security\Trusted Locations\location100" /v Description /d 3 /t REG_DWORD

Note: These settings are User based and does not affect other user which logs on to the same computer.


Advertisment to support michlstechblog.info

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.