Forum Discussion
My macros are disappearing
I think you might be on to something with One Drive. I think One Drive is trying to push itself to be used too much, and when saving, it glitches and doesn't save completely or is still processing or something and becomes read only, which clears the macros.
There's some scuttlebutt on here about EXD files being the problem, but I wonder if it's just coincidence:
http://www.lessanvaezi.com/delete-exd-files-to-fix-object-library-invalid-error/
- Thanks for that. Every time I think about it, I kick myself for not writing down the name of the files I deleted. But I wasn't thinking about macros when I did it.... so I never made the connection.
- My Excel macros stopped working after I installed Win11 and re-installed Office 365.
I reinstalled the macros --- Word and PowerPoint macros work fine --- Excel macros do not.
Initially, the Excel macros worked, until I closed the xlsm. Now the macros no longer work. Selecting a macro icon results in the message, "Office has identified a potential security concern ... Enable ... Disable." ... then "Sorry, we couldn't find ..\Book1.xlsx ...." which is odd as I have no idea where it gets that xlsx name.
I have followed the items listed above, including creating a Personal.xlsb and placed it at C:\Users\xxx\AppData\Roaming\Microsoft\Excel\XLSTART.
Any other suggestions?
---
BTW It would be good if the Microsoft Excel code writers removed all of these restrictions, located in many setting locations. It would be best if they made adding Excel macros as easy to install as Word and PowerPoint macros. This problem with Excel macros has been around for a couple of decades.bhs67 I feel your pain. Do the macros not work at all? Are they there when you hit ALT-F8?
If they are there and sometimes work, then my advice: Keep date-coded backup folders, and back them up frequently. Yeah, a pia, but this has saved me a ton of aggravation and F Bombs.
If they don't work at all, then sorry... no ideas.
Good luck.
