Microsoft Office Tutorials and References
In Depth Information
The Macro Recorder
Docking windows in the VBE has always been a bit problematic. Often, you find that
some windows simply refuse to be docked. I’ve found that if you persist long enough,
the procedure will eventually work. Unfortunately, I don’t have any secret
windowdocking techniques.
Figure 7-12: The Docking tab of the Options dialog box.
The Macro Recorder
Earlier in this chapter, I discuss the macro recorder, which is a tool that converts your Excel
actions into VBA code. This section covers the macro recorder in more detail.
This is another reminder to make sure that Excel displays the Developer tab in the
Ribbon. If you don’t see this tab, refer to “Displaying Excel’s Developer tab” earlier in
this chapter.
The macro recorder is an extremely useful tool, but remember the following points:
h The macro recorder is appropriate only for simple macros or for recording a small part of
a more complex macro.
h Not all the actions you make in Excel get recorded.
h The macro recorder can’t generate code that performs looping (that is, repeating
statements), assigns variables, executes statements conditionally, displays dialog boxes, and
so on.
Search JabSto ::

Custom Search