ScreenUpdating not working with multiple workbooks
Solved
jolord
-
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
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
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
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