Forum Discussion
My macros are disappearing
Perry320 Here is what worked for me, My excel files would not show my macros. Closed excel, restarted and opened by Personal.xlsm file. It showed my old macros under view macros.
I added some to my quickview ribbon. Left personal.xlsm open.
Opened other excel files and they now show my macros and the ones added to quick view.
No idea why this worked. But it did.
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.
