Freeze Worksheet while macro runs

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

 

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

 

[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