Excel 2003 on Windows10
I have two simple, similar workbooks.
Each has it's own associated Command Bar which is called up via an Auto Open module.
The command bar has just one button whose assigned macro closes the workbook.
In This Workbook, Workbook Activate and Workbook Deactivate are used to make the Command Bar visible true and visible false.
With both workbooks open, either can be selected as the active one using the standard Menu bar "Window" button.
The deactivated (or 'closing') workbook's associated command bar is made non-visible by the code in Workbook Deactivate
and the activated (or 'opening') workbook's bar made visible by the code in Workbook Activate.
All this works fine.
However, with both workbooks open, when one is CLOSED, Workbook Activate is NOT triggered in the other and vice versa.
The code is the same in each workbook, as follows:-
I cannot find why - any suggestions would be appreciated.
Bookmarks