If you want macros in Excel 2007 and above, and you want the files in Excel 2007 (and above) format, they MUST be saved as .xlsm macro enabled workbooks. It is not an option. Well, it is; you could also have .xlsb files.

If anyone saves the files in .xlsx format, they will no longer contain macros.


Regards, TMS