Читать книгу Excel Macros For Dummies онлайн
34 страница из 60
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.
ssss1 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.
Storing and Running Macros
Macros are stored in a workbook. Even though you work with macros in the Visual Basic Editor, the code is stored in the same file with all the worksheets, cells, shapes, or whatever else you have inside your workbook. This makes macros very easy to distribute. You simply send someone the Excel file and the macros are included.