Vista problem with NO Personal Macro Workbook in Startup Folder

  • Thread starter Thread starter AnnK
  • Start date Start date
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?
 
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."
 
Did you try closing Excel down first, then deleting the file, then opening
Excel back up and recording the macro?
 
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
 
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.
Thanks
 
Back
Top