ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selection.QueryTable.Refresh causes screen blinking (https://www.excelbanter.com/excel-programming/432965-selection-querytable-refresh-causes-screen-blinking.html)

CY

Selection.QueryTable.Refresh causes screen blinking
 
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


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com