Personal.xls Workbook

[Richard]

What is a personal.xls workbook?

[Tom Ogilvy]

Personal.xls is created the first time you record a macro and select it to
be stored in Personal Macro Workbook from the dropdown list under "Store
in:" in the first dialog after you click record new macro. (if one is not
already loaded).

Once created, it is loaded each time excel is opened manually. thus any
macros recorded in the Personal.xls or compose or otherwise exist in
personal.xls, will be available for use in the excel session.

It is no differenct from any other workbook. It is opened each time because
it is stored in the xlstart folder below the folder that contains excel.exe.
Any workbook in this folder will be loaded at manual startup. It is hidden
because it was hidden when last saved (look in windows=>Unhide).

--
Regards,
Tom Ogilvy


"Richard" wrote:

> What is a personal.xls workbook?