• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Trusted Locations

You are here: Home / Excel VBA / Trusted Locations
Trusted Locations
April 9, 2014 by Philip Treacy

If you want Excel to stop asking you if you want to enable macros every time you open a macro enabled workbook, you should think about using a trusted location.

What’s That?

A trusted location is a folder either on your computer or the network that you have told Excel you trust. Basically you are saying, any file in this folder is safe, just open it and don’t ask me if I want to enable macros.

So when you designate a folder as trusted, make sure that you really do trust that location. It should be somewhere that either you or your network administrator have control over.

Default Trusted Locations

A number of folders are trusted by Excel by default, these are shown below. You could put your files in one of these folders if you wish but I prefer to keep my files separate to anything that Excel/MS Office uses just in case that folder gets removed during a repair or reinstall of Office.

Network Trusted locations

It is possible to have a folder on the network as a trusted location, and if you work in an organization with servers, this might be the case. Check with your I.T. admin if there is a folder or folders that your organization uses for this.

A Word of Warning

It’s not a great idea to set your Documents/My Documents or your Downloads folders as trusted locations. Doing this creates an easy target for malware to exploit. You are much better off having a totally separate folder as a trusted location.

Create a Trusted Location

The steps in Excel 2007, 2010 and 2013 are virtually the same, except that in 2007 you click the Office button to start the process, in 2010 and 2013 you click on the File tab. I'm going to use 2013 in these images to illustrate the steps.

  1. Click on the File tab (or the Office button in 2007)

  2. Click Excel Options

    Options, Trust Center

  3. Click on Trust Center, Trust Center Settings, then Trusted Locations.

    Trust Center, Trusted Locations

  4. To create a trusted location on the network, check the Allow trusted locations on my network (not recommended) box.

  5. Click on Add new location. You can type the folder path\name in the Path box, or click on Browse to choose the folder.

    Add Trusted Location

  6. To include subfolders in your chosen folder as trusted locations, check the Subfolders of this location are also trusted check box

    Add subfolders as trusted location

  7. Enter a description in the Description box if you want

  8. Click OK to add the new trusted location

    New trusted location added

  9. Click OK, OK to finish and get back to Excel

Modify a Trusted Location

To modify a trusted location that you created, go back into the Trusted Locations (steps 1 to 3 above), select the location and click on the Modify button.

Remove a Trusted Location

To remove a trusted location, go into the Trusted Locations, select the location and click the Remove button.

Trusted Locations

More Excel VBA Posts

Display All Matches from Search in Userform ListBox

Display All Matches from Search in Userform ListBox

Search a range for all partial and full matches of a string, and display matching records (entire rows) in a userform listbox. Sample code and userform.
animating excel charts

Animating Excel Charts

Use animation correctly to enhance the story your data is telling. Don't animate your chart just for some eye candy. Sample code and workbook to download.
dynamic data validation lists in userforms

Dynamic Data Validation Lists in Userforms

Data validation lists using the same source that are dynamically modified to prevent the same choice being made in each list.
show report filter pages for power pivot pivottables

Show Report Filter Pages for Power Pivot PivotTables

PivotTables created from Power Pivot can't use the 'Show Report Filter Pages' option. But this piece of VBA allows you to do just that.
charting real time data in excel

Charting Real Time Data in Excel

Receive data in real time and chart the data as it arrives. Can be used to chart things like stock prices or sensor readings. Sample code and workbook
select multiple items from drop down data validation list

Select Multiple Items from Drop Down (Data Validation) List

Choose multiple items from a data validation (drop down) list and store them all in the same cell. Sample workbook with working VBA.
Excel Calendar (Date Picker) to Use in Worksheets and Userforms

Multi-Language Excel Calendar (Date Picker) for Worksheets and Userforms

Easy to use, highly customizable and multi-language. This date picker is implemented as a userform that is simple to integrate into your workbook.
automating and emailing pivot table reports

Automating and Emailing Pivot Table Reports

Automate the creation and distribution of pivot table reports with some VBA. Send reports to multiple email recipients using Outlook.
search for data with userform

Searching for Data With a User Form

Search a list of records (like a table) using a user form, and then populate the fields of the search form when the record is found.
Checking values in range objects with vba

Checking Values in Range Objects With VBA

Use built in tools or your own code to examine the values contained within Range objects in VBA. Sample code to download.
Category: Excel VBA
Previous Post:Unhide Multiple Worksheets in ExcelUnhide Multiple Worksheets in Excel
Next Post:Macro Enabled Excel TemplatesMacro Enabled Excel Templates

Reader Interactions

Comments

  1. grifance

    June 17, 2022 at 1:06 am

    My macros do not work in onedrive even after adding the folder to trusted location

    Reply
    • Mynda Treacy

      June 19, 2022 at 1:46 pm

      I’m not sure what you mean by ‘work on OneDrive’. You have to open the file in Excel for the Desktop to execute a macro. It will not run when the file is closed and it won’t run on Excel Online.

      Reply
  2. oet

    April 15, 2014 at 11:05 pm

    Useful information. Thanks for posting where these settings come from.

    Reply

Leave a Reply Cancel reply

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

Current ye@r *

Leave this field empty

Sidebar

More results...

Shopping Cart

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x