Is there any way to force excel 2007 to save in .xlsm format by default? At
the moment it seems to always try and save in .xlsx format by default
regardless of whether there are macros in the workbook or not. This seems a
little odd. Why can't excel choose .xlsm instead when macros are present so
that stuff isn't lost when you save?

In any case is there any way of changing the default file format in excel
2007? I'm assuming that the user would normally have to do something, but we
regularly send out spreadsheets with macros in it, and Excel 2007 users
equally have problems when they inevitably save it in .xlsx format.