Forum Discussion

צחי בר-אל's avatar
צחי בר-אל
Copper Contributor
Oct 08, 2017

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Excel 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.

Resources