lost all modules when opened xlsm in Excel 2003

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.
 
R

Ron de Bruin

Hi John

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

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.
 
Top