Freeze Worksheet while macro runs
 

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!

Freeze Worksheet while macro runs
 

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.

-----Original Message-----
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!
.

Freeze Worksheet while macro runs
 

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

in additon you may remove all select/activate statements but use object
references instead
--
Regards
Frank Kabel
Frankfurt, Germany

<DLS schrieb im Newsbeitrag
...
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!