Whenever I try to create a macro in the Personal Macro Workbook, I always get
the message that reads "Personal Macro Workbook in the startup folder must
stay open for recording." followed by another message "Unable to record". As
a result, I can't record a macro. How does one resolve this problem?

Dave Peterson

I wonder if excel thinks that your personal.xls* file is corrupted and
quarantined/disabled it.

In xl2003 menus, you can use:
help|about microsoft excel|disabled items

In xl2007, I _think_ it's under:
Office button|Excel Options|Addins
select disabled items from the dropdown at the bottom of that window.

You can "undisable" it--but if the file is really bad, you may find that you
have to delete it and use a backup version of the file.

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