The syntax of this name isn't correct. Macros Excel

Question

I've been using Excel and creating Macros for one of the reports, and for some reason after using it for a couple of days, when I saved and close the workbook it deleted the Macros saved in that workbook by itself. I didn't know why that happened, so I had to record the Macros all over again and create the new workbook completely separate, and after using it for some time it deleted all the Macros again. But this time before it happened I save the codes in Notepad. However, now when I try to record the Macros again, it gives me a message that says "The syntax of this name isn't correct" even though that I use recommended name, different name, this workbook, new workbook, etc. I also try to close it and reopen it, I did restart my PC, I did run Online Repair of Microsoft Office Tool and nothing helped. Please advise. Thanks

Answer 1

Hi Marijela Zegarac，

Thank you for your update and reply, I have been taken before, if you encounter any problems, you can continue to ask questions！

Best Regards

Ethan