personal macro workbook must stay open for recording


Matthew Dodds

Hi All,

If I do alt-TMR in excel to record a macro, and opt to store the macro
in personal.xls, I get a nice 'microsoft excel' OKonly popup telling me
'personal macro workbook in the startup folder must stay open for
recording'. Taking the only choice available (OKonly) gives me another
OKonly popup telling me 'Unable to record'.

So I'm currently resorting to storing recorded macros ion the current
workbook instead, which is inconvenient.

If anyone else has seen this message before and know why it appears
and, more important, how to get personal.xls working normally, then
please respond.




It may be that you do not have write access to the file or the directory
where the personal.xls file is or should be located.

Is this a networked installation or a local installation?

Also try unhiding the personal.xls workbook and seeing where it is.

-- Martin

Dave Peterson

Maybe personal.xls was disabled...

xl2002+ has 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

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

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question