Excel macros disappeared

Question

My Excel file had a load of macros and now when I click Developer - Macros, they don't show up in the list, the list is empty. How do I fix?

Answer 1

Open the file in protected mode (usually I save it on the shared network so it prompts me to "Enable Content"). You must make sure you're in the protected mode so no macros/libraries are activated.

DON'T ENABLE CONTENT

Go to Developer, Visual Basic, then click on "Debug" and click on "Compile VBA Project".

Save the file  > Close  > Reopen.

Comments

have you done this? If you open the file, force "Enable Editing" to be up top so no macros are in the file or opened, then go into macros and go to the project then do "Compile VBA Project", then it will not let you save the file, because editing was disabled. ?

---

After doing this fix.  The issue came back and now when we open file in protected view, the code is missing and the debug is greyed out.

---

If even this doesn't work, just create a new macro with error and save and close the file. Now follow the above steps.

DON'T ENABLE CONTENT

Go to Developer, Visual Basic, then click on "Debug" and click on "Compile VBA Project". At this time, you can delete the new error Macro you added.

Save the file  > Close  > Reopen.  Now all macros will appear.

---

I had the same issue, I checked all my content enablement, and everything looked ok.  I think it is a glitch.  What I did was add another module, copied the macro into that, and voila, all the macros appeared again.  So I deleted my new module, and the original still persisted.  I think I triggered Excel to "remember" it had macros in the file, by adding a module to "wake it up".  I'm a layman so take this with a grain of salt.

---

Thanks for this

---

it worked, thanks for the solution