Excel 2016 screenupdating not working

Rated 3.92/5 based on 865 customer reviews

By leaving the main window alone, and forcing other workbooks to become not visible, letting the code run, then bringing them back to visible, it stopped flickering. I have been experimenting with this technique, and although it doesn’t stop the flickering completely, it improves the result in an important way: It restores visibility to the Status Bar message, which I update every few seconds to show the application’s progress.

Making the new output workbook invisible will crash the program during some operations, but making the macro workbook invisible after adding the new output workbook seems to suppress all but one flicker, and it preserves the Status Bar display.

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

Many people write their own macros to manipulate the information in a workbook.

Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.

I'm really struggling to find anything else to suggest.

Not sure what else to suggest.djikay, thank you a lot for this, now I'm able to identify where is the bad guy messing up my setting, and you're right, it is the regress that make the setting back to TRUE. Screen Updating = False before and after the regress statement, all screens are still flickering, any suggestions on that? Also, I read somewhere that having any watches active might cause a problem, so try removing any watches you may have and see if that makes any difference.

Leave a Reply