Recording Macro Error

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
 
G

Guest

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!!
 

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