Microsoft Office Tutorials and References
In Depth Information
Figure 23-5: Excel warns you if your workbook contains macros and you attempt to save it in a nonmacro file
Introducing the Visual Basic Editor
Before you can begin creating custom functions, you need to become familiar with the Visual Basic Editor, or
VB Editor for short. The VB Editor enables you to work with VBA modules, which are containers for your VBA
Activating the VB Editor
When you work in Excel, you can switch to the VB Editor by using either of the following techniques:
• Press Alt+F11.
• Choose Developer ⇒ Code ⇒ Visual Basic.
Figure 23-6 shows the VB Editor. Chances are that your VB Editor window won't look exactly like the window
shown in the figure. This window is highly customizable. You can hide windows, change their sizes, “dock”
them, rearrange them, and so on.