VBA Excel hangs up when closing with macro

[Johnomill]

I have created a button so I can save and quit my active workbook. When I do this, Excel hangs up. In Explorer I can see that a new file is created with a strange name. When I run the macro step by step, this problem doesn't occur.
I tried different things s.a. closing with application.quit, Workbook(Name).Save, Workbook.Close Savechanges:=true, but all this results in the same problem.
Suggestions are very welcome...

Jan

 

[brans]

Hi Jan,

Have you tried

Activeworkbook.close true

Brans

 

[Johnomill]

Brans,

I tried this also and this doesn't work either. I used this methods in other workbooks and I can't figure out why it fails this time...

Best regards,

Jan