Microsoft Office Tutorials and References
In Depth Information
If your goal is to become a VBA expert, this topic nudges you in that direction, but it
does not get you to your final destination. You may want to check out another book of
mine: Excel 2013 Power Programming with VBA (Wiley). That book covers all aspects of
VBA programming for Excel.
Displaying the Developer Tab
If you plan to work with VBA macros, make sure that the Developer tab is displayed in Excel. To display this
1. Right-click anywhere on the Ribbon and then choose Customize the Ribbon to display the Customize Rib-
bon tab of the Excel Options dialog box.
2. In the list box on the right, place a check mark next to Developer.
3. Click OK to return to Excel.
After completing these steps, the Developer tab will always be displayed. Figure 23-1 shows how the Ribbon
looks when the Developer tab is selected.
Figure 23-1: The Developer tab, which does not display by default, contains commands that are useful for VBA
About Macro Security
Macros have the potential to cause serious damage to your computer. Consequently, Microsoft has added macro
security features to help prevent macro-related problems.
Figure 23-2 shows the Macro Settings section of the Trust Center dialog box. To display this dialog box, choose
Developer ⇒ Code ⇒ Macro Security.
By default, Excel uses the Disable All Macros with Notification option. With this setting in effect, if you open a
workbook that contains VBA macros (and the file is not digitally “signed” or is from an untrusted location), Ex-
cel displays a Security Warning above the Formula bar (see Figure 23-3). If you are certain that the workbook
comes from a trusted source and that the macros are safe, click the Enable Content button to enable the macros
in the workbook.