Save problem with multiple workbooks and event workbook_deactivate
 

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.

Save problem with multiple workbooks and event workbook_deactivate
 

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.

Save problem with multiple workbooks and eventworkbook_deactivate
 

THanks for your test, but i think it is not exactly the same test.
You must have the sub workbook_deactivate with a line of code in both
file book1.xls and book2.xls.
Then changed both books and closed Excel by pressing the X at the top
right hand corner of Excel.Choose 'Yes' or 'Yes to all' when the save
dialog window appears.
Nevermind if the msgbox appears or not (in this case the msgbox must
appears one time for the active workbook), the problem is (in my
case) : excel stay opened and workbooks aren't saved...

Thanks

On 17 août, 12:33, Joel wrote:
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.