corrupted Personal.xlsb?

[DocAElstein]

Hello Ian
I see you’ve been registered already some time, but its your first post so, Welcome to ExcelFox from me.

I am not sure if I know what your problem is.
But if I had a problem with my Personal.xlsb, this would be what I might try:

Delete Personal xlsb
_ But first make sure I have a copy of all my macros in my Personal.xlsb. ( Maybe in a text file, or anywhere independent of Excel )

_ Then , ( with no Excel open ), I would try to locate my Personal.xlsb.
Usually it is at a place something like
C:\Users\Elston\AppData\Roaming\Microsoft\Excel\XLSTART
C Users Elston AppData Roaming Microsoft Excel XLSTART.jpg http://i.imgur.com/MtAqemX.jpg



_ Then I would delete the Personal.xlsb file.

---

Make a new Personal.xlsb
One quick way to remake a Personal.xlsb is, from Excel start a macro recording , .._
RecordMacroFromView : http://i.imgur.com/ItZ8mQO.jpg


_... and choose the option to save it in your Personal.xlsb
StoreInPersonal xlsb.JPG http://i.imgur.com/wFcdiWV.jpg


_ Record any short macro, for example, just select a few cells, then hit the stop button
MacroRecorderStopButton.JPG : http://i.imgur.com/N8znJcA.jpg


A Personal.xlsb is then made automatically in the correct place if you choose the option to save changes to it when you close Excel
OnCloseChooseSavechangesToPersonal xlsb.JPG http://i.imgur.com/povhm19.jpg



If you then re open Excel you can put your macros back in the Personal.xlsb, which should be showing in the VB Editor
Personal xlsb in VBEditor.JPG http://i.imgur.com/4pXcLYa.jpg

---

Alan

[Ian Werich]

Hi Alan,

thank you for the quick answer.

I already knew the method you suggest to recreate a Personal.xlsb file and at this point I believe that my real problem is that my old macros are stored in old copyes of Personal.xlsb and not in text files or anywhere independent from Excel.

Does exist some tool able to read/export the macros from old Personal.xlsb files?

Ian