is there a way to disable screen updates?

I

ILiya

I'd like to disable screen updates for a time like before and after the
rutine which may produce undesired visual effects to the user like
enumerating and activating worksheets in loops and then returning to the
sheet that was originally activated.

Thanks
 
J

Jens Lenge

Application.ScreenUpdating = False

....

Application.ScreenUpdating = True

Hope this helps,
Jens
 
Top