Friday, March 02, 2007

VB Macros - How to speed them up and stop screen updates

When executing a macro you can watch everything that happens in the macro. This is good but when its all working it may be slowing down your macro. It can also be annoying to the user.

Use the following to disable the macro screen updating :

Application.ScreenUpdating = False

Then = True to switch it back on again.

No comments:

Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd