
Enabling VBA in Your Copy of Excel
By default, VBA is disabled in Office 2007. Before you can start using VBA, you need to
enable macros in the Trust Center. From the Office icon menu, you choose Excel Options,
Trust Center, Trust Center Settings, Macro Settings. Then you choose Enable All Macros.
13
Chapter 13 Using Excel VBA to Create Charts
358
If you have previously enabled the Developer tab of the Ribbon,you can use the Macro Security icon
to jump quickly to the Trust Center dialog box.
TIP
Further, when you save your files, you have to save the files as Excel 2007 macro-enabled
workbooks, with the
.xlsm extension.
Enabling the Developer Ribbon
Most ...