Forum Discussion
My macros are disappearing
My macros are disappearing. It seems to be random. There are several tricks I can use to get them back, but the problem keeps coming back.
Perry320 Douglas Cortez thank you for the responses. I figured it out a few months ago.
I have an Export macro that exports several charts as PNGs as well as a data sheet as a CSV. It turns out this macro (I think it's the CSV portion) was -- on occasion -- corrupting my files. My solution: Save the XLSM, run the Export macro, then close without saving. This has worked like a charm!
If I had to guess, it's the Export CSV portion of the code that ultimately corrupts the file. But I need both the PNGs and the CSV to support other work, so I have learned to not save the file after running the macro.
FWIW.
Thanks a bunch.