You could make the 'BeforeSave' event force-save the workbook as .XLSm, set
Cancel = True after the saving is done, and perhaps let a MsgBox inform the
user that the workbook was saved as .XLSm instead of .XLSx

CE



"Mathieu936" skrev i en meddelelse
...
On 26 juil, 20:03, Don Guillett Excel MVP
wrote:

Look in the ThisWorkbook module for before save and stop it within
that.- Masquer le texte des messages précédents -

I tried it but the BeforeSave event happens before saving. So I could
popup a message box saying to not save in .xlsx, but after user could
save in .xlsx which is bad.