Unable to record - New WB

[Dexter666]

Hi, I know that there has been some old threads about this, but none of them solved the problem. In the last time, my installation of Excel began to pop-up the ugly message "Unable to record" when I click on the record macro button (even when a new Workbook is the only one opened) and try to record it in the PERSONAL macros sheet. Then the macro will be recorded so it's rather annoying then causing a real problem, but I would like to know the reason for that and fix it. I tried these steps:

http://www.rondebruin.nl/password2007.htm

but it didn't help.

Excel Version is 2007 SP2 12.0.6554.5001
I am running Windows XP SP3
The PERSONAL.XLSB file is in his common folder (and the Read only option is unchecked).

Anyone got this same problem? Thank you for advices.

 

[jae113]

Try using Unhide to unhide the PERSONAL workbook. You should be able to unhide from any workbook using View - Unhide

 

[xenou]

This error is new to me. I might try copying my macros to a text file temporarily, killing the old personal workbook, and starting a new one. I usually let Excel create it for me (by just beginning a recording and choosing Personal workbook as the "create in" destination). Then put your macros back into the new personal workbook you've created.