Force Save as .xlsm filetype

[DJvdW]

Hi

I have created an Expense Claim form in Excel 2007, which includes a BeforePrint macro to prevent printing of the form if certain data is incorrect or incomplete. However, users can simply save the file as .xlsx, which means the macro is no longer operative.

Is there a way I can force the users to Save the file only as an .xlsm filetype?

Any help will be greatly appreciated.

Thanks
Deon

[ratcat]

G'day and welcome to the xl forum.

Try this http://www.rondebruin.nl/saveas.htm

[DJvdW]

Thank you, Ratcat. I should be able to write the code based on these examples.