VIsual Basic Editor to remain on current code window when existing .xlsm file opened.
When one is working on a procedure in the VBE and another .xlsm file is opened, the code window automatically changes to a module in the newly opened file. This is annoying when one is writing code and opens a different file to refer to it for some reason. Ideally the module shown in the code window should remain as it is. Alternatively place an option in Tools | Options ... for the user to select their preference.