| | | alf |  |
|  Posted: Sat Aug 16, 2008 9:18 pm Post subject: excel 2003(SP3) - Save problem with multiple workbooks and e |  |
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. |
|
