Save method in Excel not working

[Mack2]

I am opening an excel workbook with a macro. The opened workbook runs a "delete all code" procedure. That part is working great. But if I save the changes using the code below, when I reopen it, I get "do you wish to enable macros dialog box" (even though there is not any code).
If I close the workbook manually. When I reopen, I do not get the dialog box. Why is the save method causing this trouble? Thanks

Workbooks.Open Filename:="c:\temp\Book1.xls"
Workbooks("book1").Close SaveChanges:=True

 

[OzzieTheOwl]

I had this problem on a project I was working on, it turned out to be that the module was still there even though the VBA Code had gone, I think I got round it by copying the relevant worksheets to a new (blank) workbook, then saving the new workbook.

Hope this helps

Barney

 

[Mack2]

Thanks for the input. Sorry you had the problem, but I am glad it is not just me. I ended up copying the code in the module to the this workbook module. So now I am not using any modules. This is a very strange issue. I wonder if it is a bug.