A problem when running program code residing in another workbook

I have two workbooks: WbCode.xlsm containing my program code and WbData.xlsx containg a button to run the program that resides in WbCode.xlsm.

When both workbooks are opened, everything runs fine when pressing the button: the program does what it is supposed to do and the selected sheet in WbData.xlsx remains active (visible on my screen).
When only WbData.xlsx is open, something strange happens when pressing the button: Excel opens WbCode.xlsm and starts the program and the program does what it is supposed to do. But, when finished, WbCode.xlsm becomes active. I now have to select WbData.xlsx explicitly to see the result.

I already added

Please Login or Register  to view this content.

at the end of the program, but no changes: WbCode.xlsm still becomes active.

Any suggestion to circumvent this annoying problem ?

workbooks("WbData").activate
workbooks("WbData").worksheets("Sheet1").select ' change sheet to which one you want to show up

Unfortunately, adding the second instruction does not solve the problem: WbCode.xlsm remains active...

Try this open two blank books. select the BOOK2 and minimize it then run the following

Please Login or Register  to view this content.

that should open up book2

I do not understand the goal of this test:
First, the workbook holding the program code is assigned to Wb and then, after some Wb2.Activate's, Wb is activated.
My goal is to have the workbook without the code (Wb2 in your test) activated.

And, when changing your test into

Please Login or Register  to view this content.

the workbook holding the program code is, strange enough, activated.

I tested my 2 workbooks with Excel 2007 and everything runs fine: when pressing the button, Excel opens WbCode.xlsm (if not already opened), runs the program and WbData.xlsx remains active...
I guess Excel 2013 handles this kind of requests in another way as Excel 2007 does.
So, my question is still standing: how can I circumvent (in Excel 2013) the problem that my code workbook becomes activated ?