Display Alerts = True End Sub option back on for one of the connections and the flashing started again.
Turn screen updating off to speed up your macro code.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
When you run this example, you can compare the respective running times, which are displayed in the message box. Screen Updating = True For i = 1 To 2 If i = 2 Then Application.
Is there any way to prevent this flashing while the data is being updated?
If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.
Display Alerts = False End Sub Public Sub Stroboscope On() Application. Calculation = xl Calculation Automatic Application.
Turned it back off for that connection and the workbook no longer flashes.
This example demonstrates how turning off screen updating can make your code run faster.
The example hides every other column on Sheet1, while keeping track of the time it takes to do so.