Forum Discussion
Application.ScreenUpdating Freezing Workbook
The following macro will cause all versions of the latest releases of Excel version 2206 to lock up, even the latest version 15330.20246
Sub Excel_Freeze()
ThisWorkbook.Application.ScreenUpdating = False
For Each Worksheet In ThisWorkbook.Worksheets
Next Worksheet
ThisWorkbook.Application.ScreenUpdating = True
End Sub
This runs successfully in all prior versions of Excel. We use a similar macro to size our multi-tab business worksheets to maximize screen size. They are all not running now. The issue appears to be turning screenupdating off while iterating the spreadsheet tabs in a multiple tab spreadsheet. Commenting out the first line will stop the problem.
But I believe this to be a bigger problem in this release than just this issue.
Please fix this ASAP Microsoft (or, you know, make this default behavior to fix how terrible VBA performance is in general).
- wishicouldcodeJul 21, 2022Copper Contributor
bimbam you need to contact MS through the help feature. They dont read these unless you send it to them.