In Workbook Before Close, workbook save code not running.

[donwb]

I'm Running excel 2003 on windows 10..
I have an issue with WorkBook Before Close
In Workbook Before Close I have code to save the workbook.
This works fine when the workbook is opened and closed from itself.
However, when another workbook activates the open and close procedure for the other book,
the save does not work.
To better understand the problem, I created 2 workbooks, Workbook A and Workbook B.

Workbook A has the following code:-

Please Login or Register  to view this content.

Workbook B has the following code:-

Please Login or Register  to view this content.

If I open WB B make changes , say to Sheet 1, then close it, the changes are saved.

If I do the same, then open WB A, WB B is closed but the changes are not save, though
Copy to clipboard
Workbooks("Workbook B.xls").Save
is run.

There must be some subtle reason WB B's Workbook Close event in Workbook Before Close doesn't like being called "externally".

[davesexcel]

Hello, where would these codes be located?

[donwb]

Sorry - should have added that info.

For both Workbooks A & B , the Auto_Open and MyClose codes are each in separate standard modules.

For WorkBook B, the third set of code (containing the save instruction that doesn't run)
is located in ThisWorkbook, under WorkBook_BeforeClose.

Hope this is now clearer.