Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 22

If the thought of any macro message coming up (even one time) unnerves you, you can set up a trusted location for your files. A trusted location is a directory that is deemed a safe zone where only trusted workbooks are placed. A trusted location allows you and your clients to run a macro-enabled workbook with no security restrictions as long as the workbook is in that location.

To set up a trusted location, follow these steps:

1 Click the Macro Security button on the Developer tab.The Trust Center dialog box opens.

2 Click the Trusted Locations option on the left.This opens the Trusted Locations window (see Figure 1-6), which shows you all the directories that are considered trusted.

3 Click the Add New Location button.

4 Click Browse to find and specify the directory that will be considered a trusted location.

5 Add an optional description, click OK to close the Microsoft Office Trusted Location dialog, and then click OK again to close the Trust Center dialog.

FIGURE 1-6: The Trusted Locations window allows you to add directories that are considered trusted.

After you specify a trusted location, any Excel file opened from this location will have macros automatically enabled.