On the left side, select Trust Center, and then click Trust Center Settings.You can only clear the Trusted Documents list. Once a particular workbook becomes a trusted document, there is no way to un-trust it. To avoid this, you can change your Trust Center settings or save the file to a trusted location.
On the next opening of the file, Excel will prompt you to enable the content again. In such cases, the macros are only enabled for a single time. For examples, files opened from an unsafe location such as the Temp Folder, or if the system administrator has set the security policy in your organization to disable all macros without notification. However, some Excel files cannot be made trusted documents. What you should know about trusted documents in ExcelĮnabling macros through either a message bar or Backstage view makes the file a trusted document.
In the Security Warning area, click Enable Content > Enable All Content.Īs with the previous method, your workbook will become a trusted document.
#HOW TO ENABLE EDITING IN EXCEL MAC 2011 HOW TO#
How to enable macros for individual workbooks How to avoid these dangers? Just follow one simple rule: enable only safe macros – ones that you've written or recorded yourself, macros from trusted sources, and VBA codes that you have reviewed and fully understand. For this reason, Excel's default setting is to disable all macros with notification. A malicious macro that you run unwittingly may damage or completely delete files on your hard drive, mess up your data, and even corrupt your Microsoft Office installation. Though VBA codes are very effective in automating complex and repetitious tasks, they are a significant source of risk from the security point of view.