The Macro Recorder has been a part of Excel for quite a
long time, and it??™s still the best way to get a look at some of the objects that make up the Excel
Document Object Model (DOM), and a great way to get the core of your code written for you
as you start your development projects.
Macro Security Settings
Excel??™s default security settings do not allow any macro activity. Before you begin exploring
macros in Excel and the Macro Recorder, you will need to tell Excel which security settings to
use to control what happens when you open a workbook that contains macros (or one that
will contain macros). If you use antivirus software that works with Microsoft Office 2007 and
you open a workbook that contains macros, the virus scanner will check the workbook for
viruses before opening it.
You can make changes to the macro security settings in the Trust Center:
1. Click the Microsoft Office button, which looks like the following:
2. Click the Excel Options button, select Trust Center, click the Trust Center Settings
button, and finally click the Macro Settings item.
Alternatively, on the Developer ribbon, click the Macro Security button in the Code Group
section. (Depending on the network security level at your organization, you may or may not
have rights to change these settings).
nNote Macro setting changes made in Excel??™s Macro Settings section apply to Excel only; they do not
affect any other Microsoft Office applications.
1
C H A P T E R 1
Table 1-1 lists the Excel macro security settings and explains each setting.
Pages:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31