Microsoft Office Tutorials and References
In Depth Information
Enabling Macros in Excel 2013
To set up a trusted location, follow these steps:
1. Select the Macro Security button on the Developer tab.
2. Click the Trusted Locations button.
This opens the Trusted Locations menu (see Figure 13-10). You see all the directories that
Excel considers trusted.
3. Click the Add New Location button.
4. Click Browse to find and specify the directory that will be considered a trusted location.
Figure 13-10: The Trusted Locations menu allows you to add directories that are considered trusted.
Macro-enabled file extensions
Microsoft has created a separate file extension for workbooks that contain macros.
Excel 2007, 2010, and 2013 workbooks have the standard file extension .xlsx . Files with the
.xlsx extension cannot contain macros. If your workbook contains macros and you then save that
workbook as an .xlsx file, your macros are removed automatically. Of course, Excel warns you that
macro content will be disabled when saving a workbook with macros as an .xlsx file.
If you want to retain the macros, you must save your file as an Excel Macro-Enabled Workbook . This
gives your file an .xlsm extension. The idea is that all workbooks with an .xlsx file extension are
automatically known to be safe, whereas you can recognize .xlsm files as a potential threat.