2010年12月16日星期四

How to disable the screen refresh EXCEL

Question:

  How to turn off the animation feature EXCEL?
 That said, I EXCEL program to modify the data inside each one of his changes are shown on the screen,
 I need to change him so I finished all the later show how to change?

 Answer:
 Application.ScreenUpdating = False
 'Your code
 Application.ScreenUpdating = True

没有评论:

发表评论