Forum Discussion
My macros are disappearing
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.