{"id":825,"date":"2021-01-13T10:11:37","date_gmt":"2021-01-13T10:11:37","guid":{"rendered":"http:\/\/99excel.com\/home\/?p=825"},"modified":"2021-05-14T16:07:53","modified_gmt":"2021-05-14T16:07:53","slug":"trusted-location-in-excel","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/trusted-location-in-excel\/","title":{"rendered":"Trusted Location in Excel"},"content":{"rendered":"\n<p>If you are Excel VBA user and you don&#8217;t know about Trusted Location setting, You missed something more even you may be in trouble.<\/p>\n\n\n\n<p>You should use a trusted location to store a file when you don&#8217;t want that file to be checked by the Trust Center, or if you don&#8217;t want it to open in Protected View. This applies particularly to files with macros, data connections, ActiveX controls (what we call active content).<\/p>\n\n\n\n<p id=\"trustedlocation\">If you think the active content in a file is from a reliable source, it\u2019s better to move the file to a trusted location, instead of changing the default Trust Center settings to a less-safe macro security setting.<\/p>\n\n\n\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/Xs-PvP2TwZ4\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n\n\n\n<p>Add a trusted location<br>Click File &gt; Options.<\/p>\n\n\n\n<p>Click Trust Center &gt; Trust Center Settings &gt; Trusted Locations.<\/p>\n\n\n\n<p>Click Add new location.<\/p>\n\n\n\n<p>Click Browse to find the folder, select a folder, and then click OK.<\/p>\n\n\n\n<p>Remove a trusted location<br>Click File &gt; Options.<\/p>\n\n\n\n<p>Click Trust Center &gt; Trust Center Settings &gt; Trusted Locations.<\/p>\n\n\n\n<p>Select the location to be removed, and then click Remove, and then click OK.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are Excel VBA user and you don&#8217;t know about Trusted Location setting, You missed something more even you may be in trouble. You should use a trusted location to store a file when you don&#8217;t want that file to be checked by the Trust Center, or if you don&#8217;t want it to open &#8230; <a title=\"Trusted Location in Excel\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/trusted-location-in-excel\/\" aria-label=\"More on Trusted Location in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-825","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=825"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/825\/revisions"}],"predecessor-version":[{"id":826,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/825\/revisions\/826"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}