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