Excel macro screenupdating not working
He is president of Sharon Parq Associates, a computer and publishing services company. So I'm creating a library of commonly used macros for excel for my Excel 2011 for Mac. Close Set Destwb = Active Workbook ' do the stuff you want with this new workbook Destwb. Enable Events = True End With End Sub On a Mac in E2011 you see the screen updating, If there are problems with screenupdating code I love to hear them.
The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.This means that the Excel screen can look like it has "gone crazy" while the macro is running.In Excel 2010, you could control whether or not the screen updates while a macro is running by setting Application. In Excel 2013, screen updating cannot be controlled in this way.Screen updating is especially important for long-running macros (e.g.
Since my computer was upgraded to win 10 with office 2016, Application.screenupdating=false command in VB (excel) doesn't work properly.