Personal Macro Workbook

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
 
D

Dave Peterson

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.
 

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

Similar Threads

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Setting column width in a table with a macro is not working 0
Drop down list control value in vba 2
Save workbook without shapes 0
Personal Macro Workbook 0
Personal.xlsb does not load automatically when I start Excel 2007 14
Turning off automatic calculation 0

Top