Issues to execute two macros on two separate workbooks (but same macros) on the same time

Hi,

first, I write from Paris so apologizes for my english.

I try to launch two macros on the same time with Excel 2016. the 2 macros are located into two separate workbook and do the same code. It works in excel2007.

I have already tried to launch each workbook into new excel instance but even with that, the two macros block themselves.

Here is the code of the macros :

Please Login or Register  to view this content.

' Alm is a other macro into another file to be executute


One excel file will call Lancement_simul() with Model as file1.xlsm

second excel file will call Lancement_simul() with Model as file2.xlsm

Separately, the both executions are ok. on the same time (but into two excel different instances), the macros blocked.

any ideas, how can I solve my issues?

thanks for your future answers.

Rgds,
seb

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here