The Help page for Screen Updating Property says that it "controls most display changes on the monitor WHILE A PROCEDURE IS RUNNING." [my quotes and CAPS]. This potentially raises three questions: If I set ' Application. The Help page for Screen Updating Property says that it "controls most display changes on the monitor WHILE A PROCEDURE IS RUNNING." [my quotes and CAPS]. Excel Doctor V I am writing Word VBA (Sub) procedures that call other (Sub and Function) procedures - and I want to stop the (Word) screen from jumping about whilst they run.Many thanks in advance, Paul J Screen updating runs at the application level and should carry through all nested procedures. Once you have set it to False that should remain in effect until you explicitly set it back to True. Screen Updating = True with nothing in between them? I did like this and it dosent work: Private Sub Workbook_Before Save() Application. 1000 rows, and i see the sheet changing while saving.
Screen Updating would seem to indicate to me that the answers to my questions (above) are 1-No; 2-Yes; 3-No. Using a Watches window in the Visual Basic Environment to observe the state of Application. = When I double-click an Excel file, Excel is launched but with screenupdating off. This happens for all Excel files, regardless of whether they have any macros. I am not seeing the same behavior on my system but there are a number of systems that are apparently seeing this behavior.