Hide code execution

[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.

 

[Jan Karel Pieterse]

Hi Ys,

I want the macro to
run without the user seeing the screen flicker and jump
from cell to cell.

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

 

[David]

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