These 2 settings only allow macros from trusted sources to run. In Microsoft Office 2003, there are 4 levels of Excel macro security, which are controlled by options in the Excel menu. Warning: it is not advised that you make a large part of your drive, such as the whole of your 'My Documents' folder into a trusted location, as this puts you at risk of accidentally allowing macros from untrusted sources.

Find the directory that you wish to make a trusted location, and click OK.

From within the Trusted Locations option, click on the Add new location.

If you want to define your own trusted location, this can be done as follows:

From the 'Excel Options' dialog box that pops up, select the Trust Center Option and from within this, click on the Trust Center Settings.

Select the File tab, and from this, select Options.

Select the Trusted Locations option from the left hand menu.

From the 'Excel Options' dialog box that pops up, select the Trust Center Option, and from within this, click on the Trust Center Settings.

Select the main Excel menu (by selecting the Excel Logo on the top left of the spreadsheet), and from the bottom right of this menu, select Excel Opt ions.

This can be accessed by the following steps: In Excel 2007: Microsoft has defined some default trusted locations, which are listed in the Trusted Locations option setting in your Excel Workbook. This means that, if an Excel file is placed in a trusted location, the Macros in this file will be enabled, regardless of the Macro Security Setting.

Therefore, Excel omits the usual Macro checks when opening files that are stored in these locations. Trusted Locations in Current Versions of ExcelД¬urrent versions of Excel (Excel 2007 and later) allow you to define trusted locations, which are folders on your computer that Excel 'trusts'. Note: when you change your Excel macro security setting, you will need to close down and re-start Excel for the new setting to take effect. Select the File tab, and from this, select Options, to bring up the 'Excel Options' dialog box.From within the Macro Settings option, select one of the settings and click OK.From the 'Excel Options' dialog box, select the Trust Center Option, and from within this, click on the Trust Center Settings.

Select the main Excel menu (by selecting the Excel Logo on the top left of the spreadsheet), and from the bottom right of this menu, select Excel Opt ions, to bring up the 'Excel Options' dialog box.If you want to view or alter the Excel Macro Security Setting in current versions of Excel: In Excel 2007: Therefore, you just need to click on this button if you want to allow the macros to run.ДЄccessing the Excel Macro Security Settings This option is presented to you in a yellow band at the top of your spreadsheet, as shown below: If you Choose the second setting, ' Disable all macros with notification', when you open a Workbook that contains Macros, you are provided with an option to allow the macros to run. When you open a new Excel workbook, you are not alerted to the fact that it contains macros and may not be aware of macros running while you have the file open. This setting only allow macros from trusted sources to run. You can then opt to enable macros within the current workbook, if you want to. However, if there are macros in a workbook, a pop-up window will warn you that the macros exist and have been disabled. This setting prevents macros from running. When you open a new Excel workbook, you are not alerted to the fact that it contains macros, so you may not be aware that this is the reason a workbook does not work as expected. This setting does not allow any macros to run. The four macro security settings are listed in the following table: 'Disable a ll macros However, Excel also provides optional macro security settings, which are controlled via the options menu. The different Excel file extensions make it clear when a workbook contains macros, so this in itself is a useful security measure. Set the file type to 'Excel Macro-Enabled Workbook' and then click on the Save button. Excel will then display the 'Save As' screen or the 'Save As' dialog box (depending on your version of Excel - see right above). To do this, select Save As from the 'File' tab of the Excel ribbon. Therefore, if you add a macro to a standard Excel Workbook, and want to be able to run this macro whenever you access the workbook, you will need to save it with the. Excel recognises macro-enabled workbooks from the file extension. If you want to run macros in current versions of Excel, you need to save your Excel file as a macro-enabled workbook.

Disable macros in excel not working