Vista problem with NO Personal Macro Workbook in Startup Folder



In Vista, using Microsoft Excel, i'm unable to record or play macros from my
personal macro workbook. When I try to record a macro, i get the following
error popup: "Personal Macro Workbook in the startup folder must stay open
for recording." When i try to create a new personal.xls workbook and store
it in c\program files\microsoftoffice\office12\xlstart I get an error that i
don't have access rights to save to this folder. Ugh. Any advice?

Don Guillett

Try letting excel create it for you. Delete all personal.xls files you have
and try recording a macro to personal.xls and see what happens.


Yes, tried that. I get the error popup message "Personal Macro Workbook in
the startup folder must stay open for recording."

Rick Rothstein

Did you try closing Excel down first, then deleting the file, then opening
Excel back up and recording the macro?

Gord Dibben

You say you are running Vista and Excel.

Which version of Excel? Vista is your OS and has nothing to do with Excel.

Have a look here..........note the Ron de Bruin link.

Gord Dibben MS Excel MVP


Thanks for responses, but found the answer in developer center:

For 2007, you have to 're-enable' an add-in (that Excel has disabled) if
this happens, and here is how:

1.In Excel, click the Microsoft Office Button.
2. Click the Excel Options button.
3. In the categories pane, click Add-ins.
4. In the details pane, locate the add-in in the Disabled Application
Add-ins list. (it is an option in the drop-down at the bottom.)
5. locate personal.xls and click Enable


sorry about that. my work migrated me to new computer running Vista and
Excel 2007. I figured out problem - Excel had disabled the personal.xls file
- and i had to go to great lengths to restore it (see previous post.) all's
well now... i have my macros back so i'm most happy.

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