Try

ActiveWorkbook.Close savechanges:=False

Mike

"JanB" wrote:

Hope somebody is able to help.

I have created an macro where I am opening and using an workbook, and
then closing it again without saving it. The problem is that I cannot
close the workbook without having to clik save-yes or save-no. I do
still need to have som other excel sheets open.

I have tried to use the following code:
ActiveWorkbook.Close = False