Vba turn off screen updating

6854933580_2c8b688306_z

I've had a search and can't find anything along these lines...

I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.

Free Excel Help One drawback with recorded macros in Excel is that the code produced is often very inefficient.

vba turn off screen updating-22vba turn off screen updating-69

This means that the Word screen can look like it has "gone crazy" while the macro is running. All those Screen Updating = False's you see is called "sheer desperation". I can still enter the workbook and it is screenupdating away even right after the line set it false. Screen Updating = False" in the immediate window it works as expected. Thanks Colin Correct, when you step through in debug mode the screenupdating remains turned on. To test it properly, try this: Put a commandbutton on your sheet and paste in Application. Net) | Coordinates, Vectors and 3D volumes I've experienced this problem, with code that previously worked! Well, the function is quite long, but you're looking at the function's entry point. The immediate window says True, then False, then True again as expected, but the code doesn't seem to have any effect on the application. If all of this happens, then you know it is working correctly. Net 2003 and Office 2010 Code: Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA, VB.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. Many people write their own macros to manipulate their documents.Got round it by opening the report in design mode, closing the field list and saving again, but rather an odd feature...

You must have an account to comment. Please register or login here!