I have lost my personal macro workbook. When I try to save a new macro to it,
and error is created " Personal macro workbook in the startup directory must
stay open" "Unable to record"

Sounds like you have it as the active workbook, recording a macro to it, and
are trying to close it. You can't do that!


"GJP99" wrote in message
...
I have lost my personal macro workbook. When I try to save a new macro to
it,
and error is created " Personal macro workbook in the startup directory
must
stay open" "Unable to record"

xl2002+ have the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you'll want to put your backup copy in XLStart.

GJP99 wrote:

I have lost my personal macro workbook. When I try to save a new macro to it,
and error is created " Personal macro workbook in the startup directory must
stay open" "Unable to record"

--

Dave Peterson