save a macro

Copper Contributor

When I open vba (excel folder with macros), insert a module, copy some code and save, the macro is not saved. If I try to run it, it doesn't find any macros and asks me to create one. When I create it it generates me a high sub, ignoring my above. I have office 365

1 Reply

I might guess that the file is, and is always saved as, an XLSX? To retain macros, you must save as XLSM.