Vista problem with NO Personal Macro Workbook in Startup Folder


A

AnnK

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?
 
Ad

Advertisements

D

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.
 
A

AnnK

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

Rick Rothstein

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

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.

http://tinyurl.com/5v6upt


Gord Dibben MS Excel MVP
 
A

AnnK

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
 
Ad

Advertisements

A

AnnK

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.
Thanks
 

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

Top