lost all modules when opened xlsm in Excel 2003

  • Thread starter Thread starter John Smith
  • Start date Start date
J

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.
 
Hi John

It is possible that it delete the RibbonX but I never see that it delete the VBA code
 
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.
 
Back
Top