Saving spreadsheets with Macros

[Fear Naught]

I have a spreadsheet with Macros (VBA) and need to save as a Macro Enabled Spreadsheet. The problem I have is that some users save local copies of this spreadsheet in their default format (xlsx rather xlsm) and therefore loose the macros and VB code.

This is particularly difficult when my boss does it, makes changes to data and then sends back to me to use as the master spreadsheet for other users!!!

Is there anyway that I can get round this. Using Excel 2007 and 2010 by the way.

Thanks.

 

[ghudson]

You could put a check file extension function to verify that the file opened is in the correct format [file extension] but that would only warn the user after it is too late.

I would create a custom Save As command button for the users to use and program the file type in the code. You can probably get what you need by recording the steps in a macro.