Hide code execution

Y

YS

I am trying to find out a way to hide the procedures a
macro goes through. In other words, I want the macro to
run without the user seeing the screen flicker and jump
from cell to cell.

Thanks.
 
J

Jan Karel Pieterse

Hi Ys,
I want the macro to
run without the user seeing the screen flicker and jump
from cell to cell.
Click to expand...

Add

Application.ScreenUpdating=False

at the beginning and add

Application.ScreenUpdating=True

at the end of your macro.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
D

David

Try typing the following at the start of the macro
application.screenupdating = false
 
Top