In my case, when adding Application.screenupdating = False in my Workbook_Before Save code, it did not do it's job. yes a common occurrence is when you call another piece of code. In one particular instance I found an interesting fix: I had a Watch set.
Application.screenupdating = False was not stopping the screen update when it was call straight in an event. Screen Updating = False On Error Go To Open_Workbook1 Windows("Time M.xls"). Screen Updating = True I have had this same problem... I ran into this problem a few times myself recently.
However, I *can* change the Screen Updating from the immediate window. Screen Updating = False b Global Change Event = True Application. About to go home for the day, but I plan on trying to print Application. So while Screen Updating always is True in debug mode, this is not the issue for me.
Sub load Portfolio() Dim i Test As Integer, portfolio Version As String Application. :-) Basically, after all those statements (and between each one) Screen Updating remains "True". Screen Updating = False For i = 1 To 10000 Worksheets("Sheet1"). Screenupdating = False worked perfectly in Excel 2007 until last week, when it remained True however many times I tried to set it to False.
This can happen with recorded macros that have the word Select used frequently.
If this does happen, you may need to repeat the line: Application.