My Excel vbaProject (Personal.xlsb) has become corrupted - i cannot see any code in my modules ;-(

Question

On logging on my Laptop this morning... I opened MS Excel as normal in order to run some vba Macro's which are attached to my ribbon/custom buttons..... none worked. My personal.xlsb project will open/expand and show the names of the mods/forms - but on double-clicking - the code set will not open/appear in the right hand side.... I really need all of this code back asap (my bad i havent backed up these modules in a txt file etc) wrote these in 2022 and have been using fine since - until today! Any help would be greatly appreciated!

Answer 1

Hi @Jordan, Paul

Has Office installed any updates recently? If so, it is recommended to roll back to the previous version for testing.

If you use other devices to open this file, or change the extension name to .xlsm, can you open the file normally and view the code?

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

I really need all of this code back asap (my bad i havent backed up these modules in a txt file etc) wrote these in 2022 can you upload your .xlsm file?maybe I can try to dump those VBA codes by Python.