Forum Discussion
My macros are disappearing
I haven't had a reoccurrence since I zapped the program I mentioned above. But yours is a simple solution I will definitely keep in mind. Thanks.
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.