[Application.ScreenUpdating = False] but screen still flickers...

[cheapdrunk]

Hi all,

okies... can anyone tell me why Excel flickers even with this simple macro?

ThisWorkBook code:Dim AppClass As New EventClass

Private Sub Workbook_Open()
Set AppClass.App = Application
End Sub

TestModule code:

Public Sub sheet_modified()
Application.ScreenUpdating = False
' --- actual code goes here ---
Application.ScreenUpdating = True
End Sub

EventClassModule code:

Public WithEvents App As Application
 
Private Sub App_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Call sheet_modified
End Sub.

please note: there would usually be code between the ScreenUpdating statements but for the purposes of testing I have omitted them.

The problem I have is that even if screenupdating is turned off then immediately turned back on, my screen flickers whenever a sheet change happens!

Has anyone else seen this?

Dan

[mdmackillop]

I came across this recently. In effect the sheet has to change before the macro is triggered, hence a flicker.
Regards
MD

[XLGibbs]

You also need to disable events and calculation to prevent the flicker, as some events force a screenupdate even when it is set to False.

[smc2911]

This came up in http://www.vbaexpress.com/forum/showthread.php?t=7393, but sadly no solution emerged.

Sean.

[cheapdrunk]

Thanks everyone for your replies.

I'll give disabling events and calculation a go but probably won't get a chance to do it until this weekend (really the ONLY time I get to do any programming these days...

I'll message back with my findings!

Dan

[jayjaygross]

I was having the same issue, disabling the event fixed it for me. Thanks for your help