Application.ScreenUpdating = False not working

[Oratia623]

Hi,
For some reason Application.ScreenUpdating = False has stopped working for me.

For testing purposes, I have freshly opened Excel (2003 SP3) and into the brand new workbook, added the following macro:
*****************
Sub Test()
Application.ScreenUpdating = False
For i = 1 To 40
ActiveCell = i
ActiveCell.Offset(1, 0).Select
Next i
End Sub
*****************
When I run this macro, I see the individual values being written on the screen.
Stepping through the code and using Watch, I can see that Screenupdating is set to False by the first line, but as soon as the Activecell is changed, Screenupdating is reset to True.

If I turn events off by adding Application.EnableEvents = false to the start of the macro, all works as expected, however I do not want to use this "workaround" as I use event driven macros.

Any ideas what could be the cause?

 

[Oratia623]

Update to complete the thread - I tracked the problem down to a third party Excel add-in that had a bug. Contacted the vendor and have had them issue a patch.
Issue now resolved and I was not losing my mind after all.

Thanks for your time

 

[Richard Schollar]

Thanks for posting how you resolved your issue - I am impressed that the 3rd party vedor responded so quickly to fix the issue too.