Datasheet
Chapter 1: Using Macros and Form Controls
19
Typically, you do not share the Personal Macro
Workbook with other users. Excel creates a different
Personal Macro Workbook for each username on a
computer. If you have multiple users on your
computer with different usernames, Excel creates a
different Personal Macro Workbook for each of
them. You can copy a Personal Macro Workbook
from one user to another. The Personal Macro
Workbook is stored in the XLStart folder and is
named PERSONAL.XLSB. In Windows XP, you can
usually find the XLStart folder by following this
path: C:\Documents and Settings\username \
Application Data\Microsoft\Excel\XLStart. In
Windows Vista, you can usually find the XLStart
folder by following this path: C:\Users\username\
Application Data\Microsoft\Excel\XLStart.
Each user can only have one PERSONAL.XLSB file.
If a user already has a Personal Macro Workbook,
you should rename the old PERSONAL.XLSB file
and place the new PERSONAL.XLSB file in the
user’s XLStart folder. All files stored in the XLStart
folder open when you open Excel, and so both files
become available each time the user opens Excel. If
you have other files you want to open when you
open Excel, place them in the XLStart folder.
3
4
1
2
5
Plain Money Format
DELETE A MACRO
1 Click the Developer tab.
2 Click Macros in the Code group.
The Macro dialog box appears.
3 Click the macro you want to delete.
4 Click Delete.
A message box appears, asking you to confirm
that you want to delete the macro.
5 Click Yes.
Excel deletes the macro.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 19