Forum Discussion
צחי בר-אל
Oct 08, 2017Copper Contributor
Application.screenupdating=false command in VB (excel) doesn't work properly in WON 10 office 2016
Since my computer was upgraded to win 10 with office 2016, Application.screenupdating=false command in VB (excel) doesn't work properly. The screen flickers and the excel macro runs slowly. It happens when there is transition among excel files.
The same macro worked properly in win 7 with office 2010.
1 Reply
Sort By
- JKPieterseSilver ContributorExcel 2016 is not very friendly with screenupdating indeed and I'm afraid there is not much you can do against it other than setting screenupdating to false in your code immediately after opening a file. It will still flicker sometimes I'm afraid.