macro problem

  • Thread starter Thread starter Joker
  • Start date Start date
J

Joker

I am getting an error "Personal Macro Workbook in the startup folder must
stay open for recording" What should i do ? I couldnt find any articles
about it.

Thnx,
 
Umm, what are you doing? Sounds like you're trying to record a macro T
the personal.xls file when it's not staying open. If/when you record
macro, you can choose where to store it along with it's name an
description. Try changing that to This Workbook, see if that helps
 
Joker

Try opening excel and then
Help|about MS Excel|
Click on the Disabled Items Button

and see if your personal.xls file is listed.

If it is, try enabling it. If you can't enable it successfully--next time you
start excel, it gets marked disabled again, you may have to delete your
personal.xls file and reload it from your backup.

(and enable it one more time)

If you have no backup, move or delete elete the bad one from XLSTART folder
and create a new one by Recording a Macro to your Personal Macro Workbook.

You may have to do the Help>About>Enable thing.

Gord Dibben Excel MVP
 
Back
Top