ScreenUpdating not working with multiple workbooks

Solved
jolord -  
 jolord -
Hello,

From a macro in VBA, I need to manage multiple Excel workbooks.
To avoid having screens "flickering" when opening x files, I disable screen updating with "Application.ScreenUpdating = False".
With Excel 2016, this code no longer works, since each workbook has its own Excel application (The same issue with "Application.DisplayAlerts" which still shows messages from other workbooks).
How can I work around this?
Is there a way to open multiple workbooks in a single instance or to disable screen display for all open workbooks?

Thank you

2 answers

Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 783
 
Hello,

The issue is related to the new SDI interface that appeared with Excel 2013
The solution here:
https://forums.commentcamarche.net/forum/affich-33931181-bug-affichage-suite-a-l-execution-du-code#3

--
Best regards
Patrice
0
jolord
 
Thank you, Patrice!
0