This can result in you not knowing whether the process is still running, but the easy answer to that is to use a progress indicator bar.
Screen Updating = True Exit Sub Err_Exit: Msg Box Err. Number End Sub If you don't want to have the flicker as the documents are opened, open the documents invisibly.
In our copy of Excel 2016 (Version 15.26) for the Mac it has no effect.
It would be useful to know if there are any Excel 2016 for Mac users out there for whom Screen Updating =False does work. This comprehensive step-by-step guide will help get your database-driven ASP.
A common reason why this problem occurs is when your code calls for code in a different procedure. Screen Updating is turned on outside of the procedure. ________________________________________________________ Private Sub Clock_In() Application. Enabled = True Check_for_Open_Workbook Sheets("Time Log"). no matter what I did in code to turn off screen updating, it would not work and my app slowed to a crawl.