{"id":5259,"date":"2018-03-05T21:49:29","date_gmt":"2018-03-05T20:49:29","guid":{"rendered":"https:\/\/michlstechblog.info\/blog\/?p=5259"},"modified":"2018-03-06T15:29:28","modified_gmt":"2018-03-06T14:29:28","slug":"excel-add-trusted-location-to-execute-macros-when-a-document-is-opened","status":"publish","type":"post","link":"https:\/\/michlstechblog.info\/blog\/excel-add-trusted-location-to-execute-macros-when-a-document-is-opened\/","title":{"rendered":"Excel: Add trusted location to execute macros when a document is opened"},"content":{"rendered":"<div class=\"twoclick_social_bookmarks_post_5259 social_share_privacy clearfix 1.6.4 locale-en_US sprite-en_US\"><\/div><div class=\"twoclick-js\"><script type=\"text\/javascript\">\/* <![CDATA[ *\/\njQuery(document).ready(function($){if($('.twoclick_social_bookmarks_post_5259')){$('.twoclick_social_bookmarks_post_5259').socialSharePrivacy({\"services\":{\"flattr\":{\"uid\":\"Michl\",\"status\":\"on\",\"the_title\":\"Excel%3A%20Add%20trusted%20location%20to%20execute%20macros%20when%20a%20document%20is%20opened\",\"the_excerpt\":\"Hi%2C%0D%0A%0D%0AExcel%20can%20configured%20to%20prevent%20execute%20macros%20when%20a%20document%20is%20opened.%0D%0A%0D%0A%20%28more%26hellip%3B%29\",\"txt_info\":\"2 clicks for more data protection:\\r\\n\\r\\nOnly when you click here, the button will be come active and you can send your recommendation to Flattr. When activating, data are transmitted to third parties. \",\"perma_option\":\"off\"}},\"txt_help\":\"When you activate these fields by clicking, information to Flattr may be transferred abroad, and probably may also stored there.\",\"settings_perma\":\"Enable permanently and accept data transmission. \",\"info_link\":\"http:\\\/\\\/www.heise.de\\\/ct\\\/artikel\\\/2-Klicks-fuer-mehr-Datenschutz-1333879.html\",\"uri\":\"https:\\\/\\\/michlstechblog.info\\\/blog\\\/excel-add-trusted-location-to-execute-macros-when-a-document-is-opened\\\/\",\"post_id\":5259,\"post_title_referrer_track\":\"Excel%3A+Add+trusted+location+to+execute+macros+when+a+document+is+opened\",\"display_infobox\":\"on\"});}});\n\/* ]]> *\/<\/script><\/div><p>Hi,<\/p>\n<p>Excel can configured to prevent execute macros when a document is opened.<\/p>\n<p><!--more--><\/p>\n<p>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.<br \/>\nThis 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)<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nreg query HKCU\\Software\\Microsoft\\Office\\14.0\\Excel\\Security\\Trusted Locations\\location100\r\nreg add &quot;HKCU\\Software\\Microsoft\\Office\\14.0\\Excel\\Security\\Trusted Documents&quot; \/v DisablePromptOpenNetworkTrustedDocuments \/d 1 \/t REG_DWORD\r\nreg add &quot;HKCU\\Software\\Microsoft\\Office\\14.0\\Excel\\Security\\Trusted Locations\\location100&quot; \/v AllowSubFolders \/d 1 \/t REG_DWORD\r\nreg add &quot;HKCU\\Software\\Microsoft\\Office\\14.0\\Excel\\Security\\Trusted Locations\\location100&quot; \/v Path \/D &quot;\\\\yourFileServer\\yourShare$\\Project&quot; \/t REG_SZ\r\nreg add &quot;HKCU\\Software\\Microsoft\\Office\\14.0\\Excel\\Security\\Trusted Locations\\location100&quot; \/v Description \/d 3 \/t REG_DWORD\r\n<\/pre>\n<p>Note: These settings are User based and does not affect other user which logs on to the same computer.<\/p>\n<p>Michael<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, Excel can configured to prevent execute macros when a document is opened.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[47,134,913,1146,1147,1148],"class_list":["post-5259","post","type-post","status-publish","format-standard","hentry","category-windowsknowhow","tag-enable","tag-excel","tag-location","tag-macro","tag-specfic","tag-trusted-location"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/posts\/5259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/comments?post=5259"}],"version-history":[{"count":3,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/posts\/5259\/revisions"}],"predecessor-version":[{"id":5262,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/posts\/5259\/revisions\/5262"}],"wp:attachment":[{"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/media?parent=5259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/categories?post=5259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michlstechblog.info\/blog\/wp-json\/wp\/v2\/tags?post=5259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}