Vista problem with NO Personal Macro Workbook in Startup Folder

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

 

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

 

[AnnK]

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.

http://tinyurl.com/5v6upt


Gord Dibben MS Excel MVP

 

[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

 

[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