I'm using Excel 2010 and I have a .xla file with VBA macros, I edit the macros with the VBA editor, then save it. Later when I reopen the .xla file my changes are lost. On the internet I found other people with the same problem, e.g. MS-Excel VBA file (XLA) saving problem, but not solution.
please try to save it in the VBA-Editor. This ist what I have to do with xlam-files.