This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Maybe I'm hallucinating, but I could swear in the good old days (pre-. Refresh upon completing changes to ensure the new interface was then displayed, but allowed me to make multiple changes to the interface and the user would only see one update with all changes made simultaneously.
NET 2002/2003 Basics section of the Wrox Programmer to Programmer discussions.
NET, that is), there was a way to suppress a form refresh (Auto Refresh/Auto Redraw form property? I used to do this with multimedia programs I was working on at the time in VB3, as I recall. NET Windows application is selectively hiding, unhiding, enabling, and/or disabling some 70-80 interface objects and the form appears to be refreshing after each one is changed.
Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.
is your source for cost-effective Microsoft Excel training.
This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.
You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.
Many people write their own macros to manipulate the information in a workbook.