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.