Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
Copying select data frm one workbook to multiple workbooks & save | Excel Programming | |||
WB before save event problem | Excel Programming | |||
workbooks.open without triggering event | Excel Programming |