Lost 2 years worth of macros after yersterday windows update... Can comeone help?

[mysticmario]

As per title. I worked yestarday on my excel file which i use for all office related matters. The file is shared on onedrive. I saved tdid yerstaday and went home. Today I opened the file and all macros are gone... alt+F11 shows all the modules and userforms, but I cannot acces the view code window, also all macros in "View macros" are gone. Recovering previous versions doesn't solve this. It's like Excel doesnt see them. I opened some very old outdated local copy and it had the macros. But this would set me back months of work... Did someoen ever encountered soemthign liek thsi and can help me out?

 

[mysticmario]

I managed to fix it in a very twisted way. The macro couldn't be lost in my opinion, because there were tens of thousands lines of code in that file, if they were gone the file would get smaller and it didnt.

I opened the file via oneDrive website downloaded it opened without unlocking it in properties, therefore i was able to allow macros to be used but the files itself was locked, but I could see my macros. so I saved it as a new file on desktop, somehow it worked - now i just need to re-upload that to onderive and make it to work over there which often times also beceomes problematic. For all the people reading - this is a huge warning for people like me who want to build huge application-like excel file - it breaks a lot unfortunately. Worst of all in very odd and weird ways.

 

[jgarland]

Glad you got it sorted.

FWIW, I don't depend on Recovering a previous version, I back up my critical files every day, and save as incrementals. I also password protect my VBA code so that other folks cannot alter or delete it.

 

[Coffee_Mug_Engineering]

I managed to fix it in a very twisted way. The macro couldn't be lost in my opinion, because there were tens of thousands lines of code in that file, if they were gone the file would get smaller and it didnt.

I opened the file via oneDrive website downloaded it opened without unlocking it in properties, therefore i was able to allow macros to be used but the files itself was locked, but I could see my macros. so I saved it as a new file on desktop, somehow it worked - now i just need to re-upload that to onderive and make it to work over there which often times also beceomes problematic. For all the people reading - this is a huge warning for people like me who want to build huge application-like excel file - it breaks a lot unfortunately. Worst of all in very odd and weird ways.

I don't know how you figured this out but THANK YOU. Worked for me.