This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I had a problem with Excel 365 suddenly removing my macros from the macro list under Developer. The macros were still there, and can be run manually via the VBA editor. I found a simple fix. I just went to the editor, displayed the module with the macros and then selected all (ctrl-A), cut everything (ctrl-X) and then pasted them back (ctrl-V). And voila, the macros reappeared in the macro list and after saving, seemed to remain there when I reopened the file. I have no idea what happened, but this is a simple fix.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The reason is that the module is re-compiled and therefore the list of macros is refreshed.
Next time add a line at the top, delete the line immediately, in the menu click Debug \ Compile.
That should have the same effect.
Andreas.
Same thing happened to me today. Cut and Paste worked. Thank you!!
Great discovery, this worked for me too, thank you very much PaulN-SF
Oh my god, thank you for this answer! This issue drove me nuts!
This happened to me today. Very weird! Your fix worked great, thanks.
I've noticed this a couple of time recently, except the other time, the file was corrupted and I had to rebuild the whole thing.