Microsoft Office Tutorials and References
In Depth Information
Open the VBA Editor
Open the
VBA Editor
If you want to view or make changes to your
recorded macro, or if you want to create
macros from scratch, you need to open the
VBA Editor.
After you finish recording your actions, Excel
translates them into VBA statements. Excel
then saves the macro in a module, a special
window in which you can view, edit, and run
macros. If you are satisfied that your recording
is accurate and properly executed, then you
may not need to view the module in which it
was stored. You can run the macro from Excel
any time you want; for more information, see
the section, “Run a Macro.”
However, if you make mistakes during the
recording, or if you want to augment the
recorded macro with other VBA statements,
then you need to view the module to work
with the macro. Similarly, you also require
access to the module if you want to paste
macros from other sources or create new
macros from scratch.
In both cases, you can access the module using
the VBA Editor, a program that enables you to
view, create, edit, and run VBA macros.
1 Click the Developer tab.
2 Click Visual Basic.
Note: See the section “Record a
Macro” to learn how to display the
Developer tab.
1
2
You can also press
Alt+F11.
The Microsoft Visual
Basic for Applications
window appears.
3 Click the plus sign to
open the workbook that
contains the recorded
macro.
3
PERSONAL.XLSB is the
Personal Macro
Workbook.
If you do not see the
Project pane, click View
and then click Project
Explorer, or press Ctrl+R.
 
Search JabSto ::




Custom Search