Excel macro application screenupdating not working

Rated 3.92/5 based on 674 customer reviews

So from my viewpoint Screen Updating is not working correctly.

This is an issue because when activating some sheets, I am doing things in the background that have been "Hidden" to this point but with screenupdating all ways "on" the user will see everything.

Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.


It works on other macros fine, but no dice on this one. For the screen to be updating then either the sub is ended or somewhere screenupdating is turned back on.

Check if the sub calls other subs or functions that update the status of application.screenupdating. Click the star icon in the lower left part of the contributor's post and add Reputation. Mark your thread [SOLVED] if you received your answer.

Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.

Screen Updating is turned on outside of the procedure.

Leave a Reply