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.
Hence, what I did is to follow tjeffryes' recommendation and created a new watch on any variable.I set it to "All procedures" and "All modules" for the context, ran the procedure as usual in debug mode, then deleted the watch, closed the VB Code editor, and it was back to normal, the screen not being updated as my code was stating properly! I was able to solve my issue by deleting the Application. It appears that there is no single solution to this problem.I really hope this will help some other people coming here for the same issue since indeed, this is the kind of things very time consuming and going you crazy! yes a common occurrence is when you call another piece of code. Each person may be experiencing it for a different reason.As the macro swaps from one to the other on my Mac it shows where the focus is so I see the 2 worksheets swapping but if I run the exact same macro on a PC it doesn't.Screen updating is set to false at the start and to true at the end only with no sub routines called but I do call functions there is no reason to move selection or activate each workbook, just read and write fully qualified ranges activating workbooks or sheets, or selecting ranges in macros is bad practice and leads to errors in results and other issues AFAIK the is never any need to set application.screenupdating to true, as this will happen automatically when the code finishes i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Search for vba screenupdating:
Screen Updating = False" statement) while the "Application.