Excel crashes when closing an Active Workbook with VBA

When I run my macros on Excel it crashes at:

ActiveWorkbook.Close savechanges:=True

The workbook is saved but it quits excel application. So if I have other excel files open, all the files are closed.

I also tried ActiveWorkbook.Close because I save it first anyway.
But then also it crashes.
However when I block the close line from the macro it runs fine and no crashes.
But oufcourse I rather have the workbook closed automatically after it is saved.

This is the part of my code that goes wrong:

Please Login or Register  to view this content.

Does anybody know why it keeps crashing on me and how it could be solved?
Thanks!

Tried now several runs with your solution and seems not to be crashing anymore
Thanks a bunch!

Apparently I spook too soon
Yesterday all day all went fine but when I try my macro today it still crashes everytime....
Getting a bit frustrated....
Anybody more suggestions about what could cause this anoying behaviour?

Hi,

Try this formula instead?

Formula:

Please Login or Register  to view this content.

Thanks
Lex