Forum Discussion
My macros are disappearing
Nevin930 I have the same thing happen with my macro-heavy workbooks, and it's gotten so bad that I am constantly saving backup versions to date-coded folders (with descriptions of any changes) cos this problem is arbitrary, chronic, and infuriating. In some cases, my previously-fine backups (I always check to see if the macros are there with [ALT]-[F8] before closing) are likewise corrupted. This has been going on for years, and the "just back up every new version" has become the only way to save my work from total Excel annihilation.
It's April 2, and I still haven't had one macro disappear. Since my last post, I have discovered another workaround. Buttons. I was able to get rid of 26 macros on one file by using option buttons. On another file, radio buttons. But I still have a couple simple ones, and they haven't vanished. I MIGHT have remembered the icon that mysteriously appeared on my computer: One Drive. I'm not sure, but I saw the icon somewhere, and it struck a cord. Good luck. I was on the brink of giving up a project I had been working on for a year because of this problem.
Perry320 mine are data-intensive crop-yield modeling workbooks that are linked to databases for weather data, crop yield data, and satellite vegetation health data... so I am sure I am pushing Excel to the limits. But I am also the only person in our office this keeps happening to. It just happened now, and the previous two versions of the workbook I backed up, which worked fine when I backed them up, are likewise f___ng corrupt and now useless. This sends me to a dark, angry place. I suspect there is either a DLL file or something within my MS Office or Excel that is corrupt. Our IT has already wiped my MS office clean and reinstalled it, and that doesn't seem to have stopped the problem. I am really at my wit's end.