Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

 

 
 
 
 
 
 
 

 

 

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

 

Mob: 0421 551 254 Email Us