Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next it is something that I inherited and has about 2k lines in total adding info from 3 sources so I don't want to rewrite it (and yes there are many functions to reduce it to that number).IS there a way of stopping it from doing this on a Mac to save me that pain?
no matter what I did in code to turn off screen updating, it would not work and my app slowed to a crawl.Check other procedures that are called within your current one to check if they are changing your Application. However, as soon as I removed the watch, it worked fine. I ran into this problem a few times myself recently.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.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.