Can't set application.screenupdating = False ... Going insane...

[9tanstaafl9]

I can't seem to turn off screenupdating for any macros on one workbook. I do not have this problem with other workbooks.

My macro does not crash, it appears to run properly, and when I step through the code line by line it appears like the application.screenupdating = false is being run. But if I hover over it in the editor it says that it is application.screenupdating = true.

I tried setting a watch for all procedures, and it says that the screen updating IS being changed to False when it should be, yet it isn't. If I check the status of screen updating immediately after the watch verified the change switched to false, it still says that it is TRUE.

I have tried using the immediate window with the following code after restarting excel and running no macros:
application.screenupdating = false
msgbox application.screenupdating (which responds with "True")

Any ideas?

Excel 2013, I don't have any add-ins, no other programs opened before testing, I commented out everything in my personal.xlsb, I did not open any other workbooks after restart before testing. No variables declared outside the module. No on_open or anything like that.

And please don't just tell me to get rid of my selects and it won't matter. One, I've already got rid of all of them that I could, and two, I'm just nuts enough that even if the screen wasn't flickering, it would drive me crazy not to know WHY this is happening.

I've been trying to figure this out all day. I've googled it to death and can't find an answer. Any guidance appreciated. Note that I'm about a level 3 out of 10 at VBA so it's possible I've done something incredibly stupid.

Thanks in advance!

 

[Jerry Sullivan]

My point was that it is happening on all the macros, even the simple ones, and even in the immediate window before any macros have been run. Macros with screenupdating hat work in other workbooks but not this one. I think there has to be something in on the spreadsheet itself that may be causing this trouble, but I can't figure out what it is. Unfortunately, I've inherited this workbook, which has MANY sheets and lots of weird formulas.

Have you tried running the same tests on that problem file on a different computer?

If the problem is repeatable on other computers, I'd be interested in taking a look at a copy of the file (with any sensitive data removed).

 

[RoryA]

If you're stepping through code, ScreenUpdating is always True. Equally, setting it from the immediate window won't work because it's reset as soon as your code finishes.

 

[9tanstaafl9]

If you're stepping through code, ScreenUpdating is always True. Equally, setting it from the immediate window won't work because it's reset as soon as your code finishes.

Well then that explains it. I'm really sorry for wasting everyone's time. I had really thought that it had shown as FALSE in the past. Please disregard my question. I really wish there was some way to delete stupid posts.