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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forwards/backward compatibility Excel 2003-2007 8
Open xlsm as a template file 1
xlsm SaveAs xls 4
xltm saveas xlsm 6
Save As and new workbook new name used in existing code 8
xlsm.zip files do not show as folders in Explorer 2
Saving in .xlsm format by default 6
Excel 95 equivalent of modern events? 6

Back
Top