View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tonyhabayeb tonyhabayeb is offline
external usenet poster
 
Posts: 5
Default How to stop all Excel funtions for a period

Thnx a lot.

I used the following command to disable and enable it:

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

..... my code is here ....

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic