I have an auto_open macro on a workbook that performs some functions, then
does a save as with today's date as the file name. The problem is that the
new file has the auto_open macro in it too, and when I open it, the macro
runs. I would like to put some code in to prevent the macros being saved
with the new sheet, or in some way delete the auto-open before it saves. Any
ideas would be welcome.

Regards

Alan