Disappearing Custom toolbars.

I'm using Excel 2003 VBA on windows 10.
I have two Excel files open, each of which has it's own VBA generated custom command bars.
If I switch between them using the "Window" button on the standard menu bar, my custom command bars are retained correctly.
However, if I close one of the files using the code “ActiveWorkbook.Close”, the other file appears but minus the custom bars.
BUT if I close the file using the yellow file close icon on the standard toolbar, the other file appears complete with custom toolbars.
I want to use “ActiveWorkbook.Close”, as there is other associated code in my ‘close’ module.
What’s happening here?

.
Does it function as needed if you use the command : ThisWorkbook.Close ?

Hi Logit

Thank you for your reply.

Unfortunately ThisWorkbook.Close made no difference.

What I don’t understand is that when I use this code to close one file and the other appears (minus custom bars) no [ Activate] event is triggered.

However, using the menu bar yellow Close icon, a Workbook_Activate procedure (where I have code to generate the custom bars) is triggered and the bars are preserved.

It’s this apparent inconsistency I can’t unravel.

.
Interesting puzzle. My experience with Custom Tool Bars is ZILCH ... I'm not going to be any help.
But I am going to follow this thread to see what other, more informed folks have to say.

I have posted the 2 folders Test_CB1.xls & Test_CB2.xls
Test_CB2.xls has an ‘extra’ module called CloseMe.
If both folders are opened, and Test_CB2.xls selected, using the standard toolbar yellow close icon closes the file and when Test_CB1.xls appears, it shows CBBar_2 intact.
However if the procedure is repeated and Test_CB2.xls is closed using the CloseMe module in VBA, then when Test_CB1.xls appears, it is minus the CBBar_2 toolbar.
This is the problem.