Personal Macro Workbook

There is nothing special about the personal.xls workbook-- it is just another workbook. You can automatically create one in the default location (the XLStart folder) by simply recording a macro to do anything and changing the "Store Macro In" setting from "This Workbook" to "Personal Macro Workbook".

In my case, it was saved in

C:\Documents and Settings\dliu\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS

Most people hide their personal.xls workbook. Open it, then go to the Window menu and choose Hide. This way, the workbook will be open and available, but not visible. You can always access the Macros in PMW by switching to VBA window.

In fact any file in XLStart will be automatically opened when Excel starts.

Our lab computers protect their C disks. Anything you save on C will be gone once you log out, including the personal.XLS. So make sure you backup PMW in your personal folder before logging out.

2/28/2005