I suppose your real question might be how to open or repair or get macros from a corrupt workbook?
I think there a lot of both free and commercial software’s to try and do that.
I am not familiar with any myself, but I expect an internet search on something along the lines of “open or repair or get macros from a corrupt Excel workbook” will give you a months worth of stuff to look into.
I am sorry but I don’t personally have any experience with using any particular tool. I know that there are a vast amount out there. I have personally been lucky never to have lost anything in a corrupt workbook that I did not have a back up of, but it is a problem that comes up a lot.

But I may not yet understand exactly what your problem is.


What I just did try was to take a copy of my Personal.xlsb , store it on an arbitrary place ( my desktop ) and then changed its name to some arbitrary name. I was then able to open it as a normal Excel file and see all the macros in it.

If you are unable to do that with any of your backup Personal.xlsb versions, but can open any other Excel workbook, then that would suggest that you have a lot of corrupt old Personal.xlsb files

Or maybe I don’t quite understand what you are referring to by regularly backup Personal.xlsb versions and restore an old version Excel

I am sorry if I have mis understood your actual problem and so i am talking rubbish…
Perhaps you can share a screenshot of the error you get? ( Please try to make a screenshot size of at least 50K , since our forum software tends to make anything smaller than that come out rather difficult to read )

Another possibility is if you upload a workbook that you are having difficulty opening, then I can try to open it on my Excel. I have a lot of different computers with different Excel versions on them, so I might get lucky and find that I can open the file somehow and make a copy for you of all the macros in it, then return them to you both in a text file and/ or in another Excel file