Recording Macro Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When trying to record a macro under the Personal Macro Workbook, I get an
error that says: "Personal Macro Workbook in the startup folder must stay
open for recording." Followed by another error: "Unable to record." I've
recorded macros before and all of those that were saved are now gone.

Any ideas?

Thanks
 
Not a solution, I'm afraid, but I make use of the 'Auto_Close' macro to save
a copy of my Personal.xls to a different location every time XL closes just
in case something like this happens.

Ah. I've just managed to replicate the error messages by closing
Personal.xls and then trying to record a macro to Personal.xls. When you
look in VB Editor, none of the macros are visible because Personal.xls isn't
open!!
 
Back
Top