Freeze Worksheet while macro runs

D

DLS

Can somebody tell how to freeze a worksheet while a macro runs to
eliminate the sheet jumping around? Thanks

DLS

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
E

Eva Shanley

Hello,
Application.ScreenUpdating = False will fix your problem.
When the macro is done executing, you should type
Application.ScreenUpdating = True to turn it back on.
 
F

Frank Kabel

Hi
use
application.screenupdating=false
'your code
application.screenupdating=true

in additon you may remove all select/activate statements but use object
references instead
 
Top