|
Stop the user seeing the actions a macro is performing
To stop a user seeing the screen change whilst a macro is
running, set the screen updating property to false. You must also set the
screen updating property to true before the end of the macro.
Sub MyProgram
Application.ScreenUpdating = False
Your Code
Application.ScreenUpdating = True
End Sub
VBA Tips Index
|