Stop Users Saving Macro Enabled File as ".xlsx"

[OzTrekker]

Hi Folks,

I have an Excel 2010 macro file (.xlsm).
For some reason uneducated users are saving it as a ".xlsx" file and then complaining that the macros don't work.
Is there any way I can stop them from doing this?

[6StringJazzer]

Add the following code to your ThisWorkbook code module. This will trap an attempt by the user to do a "Save As" and simply save the file with the existing name. The user will never see the "Save As" dialog box. However, this will also prevent the user from trying to save the file with a different name or in a different location even if they want to keep the ".xlsm" extension. (I know of no way to allow the user to bring up the "Save As" dialog but interrupt the save if he tries to use a different extension.)

Please Login or Register  to view this content.