Vba excel screenupdating false not working

28 Nov

Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell. Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell. I've got a massive bit of code running that takes 30 mins to run and I have it set so that screen updates set to false while most of the code runs but every now and again I turn it to true and straight back to false.In 2003, 20 doing this enables the screen to temporarily update so you get a visualization of what the sheet now looks like however in 2013 it doesn't work...

Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. I wanted to leave a comment but I am not allowed to do so. Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately. Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application. Add this newly created add-in to your add-in references and away you go. Excel will default save it to your add-ins directory.