Macros I created using VBA code disappear in future sessions. They appear to
have been created initially in the Personal Macro Workbook

Does Personal.xls not open when you start Excel?

Look for it under Unhide in WindowsUnhide.

Is it there?

If not, check out HelpAboutDisabled Items

Has Personal.xls been disabled?

If so, enable it and see if your macros are available.

And.................are you sure the macros were created in Personal Macro
Workbook?


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 12:53:01 -0700, Ellen
wrote:

Macros I created using VBA code disappear in future sessions. They appear to
have been created initially in the Personal Macro Workbook