I have excel 2003. I put the code into book1.xls and saved the file. I then
create book2.xls with no code and saved the file. I then changed both books
and closed Excel by pressing the X at the top right hand corner of Excel. I
got the response to Save All books and picked All. The message box never
came up. If I just closed book1.xls I got the message box.

I'm getting a little bit different response then you explained so I want to
make sure we are doing exactly the same thing.

"alf" wrote:

Hello
I have 2 workbooks opened, with a workbook_deactivate sub defined
When I ask to close (red cross), the save window appears and i click
to 'Yes to all', but the workbooks stay opened, and not saved! the
problem is not on my code, because if i have a sub like that:

Sub Workbook_deactivate()
msgbox "hello"
end sub

the problem is still here.
And if i remove completely this sub, it works fine(workbooks saved and
closed!

It can be tested very easily. Create 2 workbooks with the
workbook_deactivate like here, then modify any data in sheets of the
two workbooks, then click on the red cross, and answer 'Yes' or 'Yes
to All'

Do you reproduce this ?
Have you any idea to sove this problem ?
Thanks for your help.