I have two similar workbooks with
- Activate Event to show/create customed toolbars
- Deactivate Event to hide/remove customed toolbars
- Exit routine (reside in a Module) to save and close the workbook (and trigger the Deactivate Event)
However, while closing one workbook through the Exit routine (not by clicking the close button) does trigger the Deactivate Event to remove the customed toolbar, it does not trigger the Activate Event of the second workbook to bring back its own toolbar.
Can anyone help?