C
CY
Hello,
I have a macro looks like that:
Sub Macro1()
'Application.ScreenUpdating = False
Selection.QueryTable.Refresh BackgroundQuery:=False
Application.OnTime Now + TimeValue("00:00:01"), "Macro1"
'Application.ScreenUpdating = True
End Sub
The excel screen blinks every 1 second. It is quite annoying.
I want to make sure that there is no way to stop the blinking
even with "Application.ScreenUpdating = False" which I have tried.
Thanks,
CY
I have a macro looks like that:
Sub Macro1()
'Application.ScreenUpdating = False
Selection.QueryTable.Refresh BackgroundQuery:=False
Application.OnTime Now + TimeValue("00:00:01"), "Macro1"
'Application.ScreenUpdating = True
End Sub
The excel screen blinks every 1 second. It is quite annoying.
I want to make sure that there is no way to stop the blinking
even with "Application.ScreenUpdating = False" which I have tried.
Thanks,
CY