Excel 2010 application.screenupdate = false turns events off?

Hi experts,

This is more an observation for the public realm, but I am interested if anyone else has experienced this?

I had a machine (only happened on 1) that the line "Application.ScreenUpdating = False" appears to have turned off the Application.EnableEvents and I need to put the line Application.EnableEvents = True after the line Application.ScreenUpdating = True

LVL 1
Craig LambieAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
Something to try: debug your code on the problem box. Use this version and step through the code to see exactly what happens and when:

Debug.Print Application.EnableEvents
Application.ScreenUpdating = False
Debug.Print Application.EnableEvents

You can see the Debug.Print results in the Immediate window.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
That should not happen. Do a search through all your code for Application.EnableEvents = False and I'll bet there is one or more and it was triggered.

Kevin
0
 
Craig LambieAuthor Commented:
Hi Kevin,

I did that search. Nothing.
Also I looked for anything that could set it off.

Funny thing was that it only happened on one particular machine, not on any others.

C
0
 
zorvek (Kevin Jones)ConsultantCommented:
It could also have been another workbook or add-in that cause the property change. But it should not have happened with your code as it is.

Kevin
0
 
Craig LambieAuthor Commented:
I am back with this client in a couple of days, I will try that on their machine.  Is most likely your first post as they used quite a few plugins, but no non standard ones as far as I could tell.

C
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.