lost all modules when opened xlsm in Excel 2003

[John Smith]

When I opened an Excel 2007 xlsm file in Excel 2003, all the
modules were gone. Anyway to recover the modules without using
Excel 2007? Thanks.

 

[Ron de Bruin]

Hi John

It is possible that it delete the RibbonX but I never see that it delete the VBA code

 

[Ted Mercer]

From within Excel 2007 always save the file using the Save As Excel 97-2003
Workbook format, found on the Office Button, so as to maintain the .xls name
extension. Your file will then work in both versions provided you do not
need a feature that is exclusive to Excel 2007.