Microsoft Office Tutorials and References
In Depth Information
MAKE A PERSONAL MACRO WORKBOOK
When you click OK, the macro recorder runs. You have to do at least one
action in Excel that is recordable. Perhaps you can press Ctrl+B to bold the
current cell or type Hello in the current cell. After you have performed this
action, you can stop recording. The reliable way to stop recording is to choose
Tools, Macro, Stop Recording. You might also see the Stop Recording button
on the tiny Stop Recording toolbar (Figure 98).
Figure 98. You can click this but on
to stop recording.
Figure 99. You want to locate PER-
SONAL.XLS in the Project Explorer.
When you’ve recorded a macro, Excel creates the Personal Macro Workbook.
On my Windows XP computer, the ﬁ le is stored in C:\Documents and Settings\
Bill \Application Data\Microsoft\Excel\XLSTART\Personal.xls.
The Personal Macro Workbook is a hidden workbook. There is nothing special
about the workbook. If you are curious, you can unhide it by selecting Window,
Unhide and then selecting PERSONAL.XLS and clicking OK. It should contain
one worksheet and will be completely blank. All the good stuff in the Personal
Macro Workbook is visible from the VBA editor.
To see the code pane in the Personal Macro Workbook, follow these steps:
Press Alt+F11 or select Tools, Macro, Visual Basic Editor. If you have never
used macros before, you see a menu bar, a toolbar, and a lot of gray.
Press Ctrl+R or select View, Project Explorer to show the Project Explorer
pane. As shown in Figure 99, the Project Explorer lists each open workbook,
plus one workbook for each standard add-in installed on your computer.
Figure 99 shows the workbooks in collapsed mode. You might ﬁ nd that
some of your workbooks have been expanded to show worksheets and