Not a lot of information there for us to go on. Let me take a guess though... you forgot to save the workbook as an Excel Macro-Enabled Workbook (*.xlsm).Why My macro disapeard
Unfortunately, I do not have an answer for you. Sorry. Hopefully, someone else reading this thread will.[record and save some macros. I use them for a few days, all okay.
I return to the spreadsheet a few days later and all of the macros are gone.
Why