Forum Discussion
Excel Macros disappear from xlsm file
Hi, since a few days we are experiencing the following on several computers (we are O365 customers and Excel is always update automatically (Version 2311 build 17029.20068) with Excel: We are...
Hi Jazz since I updated I've not had issues. I'm keeping my fingers crossed and my files backed up though.
I found the following on another site and it worked for me but I still want to know why it's happening.
Open the file in protected mode (usually I save it on the share network so it prompts me to "Enable Content"). You must make sure you're in 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.
MKirsch Thanks for sharing... that worked for me too 🙂
