Personal Macro Workbook

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I'm trying to create a macro which I want to store in the Personal Macro
Workbook. I'm getting a message which says "Personal Macro Workbook in the
startup folder must stay open for recording". I'm not sure why I get this
message, and it's preventing me from recording a macro. What do I need to do
to fix this problem?

Ivor
 
A few people have posted this problem. One of the solutions is that excel kept
closing the personal.xls file because it thought was corrupt.

If you're using xl2002 or xl2003, you may be having the same trouble.

If you start excel, then click on Help|About MS Excel, then disabled items, do
you see your Personal.xls workbook?

If you do, try to enable it.

If that works, then woohoo.

But if excel still thinks that file is corrupt, you'll want to replace the
personal.xls workbook with your backup version.

Then go through that same stuff to enable it.
 
Back
Top