Quote Originally Posted by urungus View Post
The macros I have embedded in my excel files are being stripped out when my coworkers modify them using excel 2007 and then save the files in the default 2007 file format.

Is there a way to force the sheet to be saved in Excel 2003 format, thus preserving my macros (maybe using a Workbook_BeforeSave subroutine)?

Thanks.
That cannot be happening with a save, especially if they save as *.xlsm .

Please post in the correct Forum, I am moving this to the 2007 Forum