Freeze Worksheet while macro runs

  • Thread starter Thread starter DLS
  • Start date Start date
D

DLS

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

DLS
 
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.
 
Hi
use
application.screenupdating=false
'your code
application.screenupdating=true

in additon you may remove all select/activate statements but use object
references instead
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Freeze animation 1
Run Macro If Cell have "x" value 0
Freeze the value of one cell for secs while worksheet auto updates 4
Run macro on all files in a specific folder 3
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Need Macro... 8
Screen flickers while macro is running 4

Back
Top